Checking for the exsistance of a column.

[jeffmoore64]

How do I check for the exsistance of a column in a table and if it is not there add it.
TIA
Jeff

 

[gmmastros]

If Not Exists(Select * 
              From   Information_Schema.Columns 
              Where  Table_Name = '[!]YourTableName[/!]'
                     And Column_Name = '[!]YourColumnName[/!]')
  Alter Table [!]YourTableName[/!] Add [!]YourColumnName[/!] int

-George

Strong and bitter words indicate a weak cause. - Fortune cookie wisdom

 

[ptheriault]

IF NOT EXISTS(
select *
from information_schema.columns
where TABLE_NAME = 'YourTableHere'
AND COLUMN_NAME = 'YourColumnHere')
BEGIN
ALTER TABLE ---
END

- Paul
- Database performance looks fine, it must be the Network!

 

[jeffmoore64]

Thanks