How to check whether column exist or not in a table.

[umeshs79]

Hi,
I want to check whether a particular column exist or not in a given table. This i want to check before dropping the column so no error comes if column is not present.

So please can anybody tell me how i do this?
Exmple:
--How to do: check if column exist
-- if exist
ALTER table table_name DROP COLUMN column_name

Thanks Umesh Sharma,MCSD
India

 

[topher0303]

You can use the information schema views as so:

if exists(select 'x'
from information_schema.columns
where table_name = 'test5'
and column_name = 'col2')
begin
alter table test5 drop column col2
end


Chris.