SQL check if column exsit and add it if not

[darhal]

Hello all,

I m using SQL for specific system and after some time of using this system the database being full of data and I dont want to create another one so I lost them and time I forget to add column to the table from the beging so how to add it now without damaging or deleteing the db ?

THX all

[GTX]

ALTER TABLE table_name 
ADD column_name datatype 

[darhal]

Does it check if a colum is added or not ?

[GTX]

Yeah, it won't add 2 columns with same name obviously.

[darhal]

We use it like this ? for eg

dbExec(dbc, "ALTER TABLE houses ADD pets datatype") 

[GTX]

datatype must be data type, i.e TEXT.

[darhal]

THX a lot I will try it btw ;D