Tag Archives: Column Exists

Checking if a Table Column already Exists in a SQL Table

On odd occasions it is necessary to test a table to see if a column already exists. This is basically accomplished by checking the database system tables ‘SysObjects’ and ‘SysColumns’ for the relevant data. The example below shows such a … Continue reading

Posted in SQL 2005 | Tagged | Comments Off on Checking if a Table Column already Exists in a SQL Table