Checking for the Existence of a Column in a SQL Server Table

You can check if a column exists in a SQL Server table using the INFORMATION_SCHEMA.COLUMNS system view, through a simple SQL query.

Read more