How do I check if a column exists in SQL Server?

Question

How do I check if a column exists in SQL Server 2000?

Accepted Answer

```
IF EXISTS ( SELECT * FROM INFORMATION_SCHEMA.COLUMNS
WHERE  TABLE_NAME='tablename' AND COLUMN_NAME='columname' )
```

Solution