There are at least 3 ways to find out if the column in table exists in MS SQL server. It's a common task for developers or administrators when you need to modify table.

1. Using COL_LENGTH

 

2. Using sys.columns

 

3. Using INFORMATION_SCHEMA.COLUMNS