try like:

select*

fromINFORMATION_SCHEMA.COLUMNS

whereCOLUMN_NAME = 'your column name'

go