Checking for existence of column in table

[nodoubtom]

How do I check for the existence of a column in a table for SQL Server 2005.

Thanks!

 

[ptheriault]

select * from information_schema.columns
where column_name = 'what ever'
and table_name = 'yourTable'

- Paul
- If at first you don't succeed, find out if the loser gets anything.

 

[nodoubtom]

Thanks for your quick response. When I run this without the WHERE it's not pulling back all columns that I know are in the table. Why would this be?

Thanks!

 

[nodoubtom]

Sorry. I was in the wrong DB. That's why it wasn't finding it! Thanks for your help!!!