add column if not exist

Dj Kat · February 16th, 2006, 04:53 AM

Hi,

I would like to add a column to a table.

Code:

ALTER TABLE tb_form
ADD Form_subject char(50)

How ever I want this query to be done if the column doesn't allready exists in the table.

how can this be done

thnx

__________________________________________________ ________
This is my junk I'm gona eat it

ChrisScott · February 16th, 2006, 01:57 PM

I don't think you can do this directly using sql.

You could run a "DESCRIBE yourTableName;" query, then check the value of the "Field" column for each record to find out whether it matches the field name you want.

HTH,

Chris