To obtain information about table columns in Microsoft SQL Server, use the INFORMATION_SCHEMA.COLUMNS view:

SELECT COLUMN_NAME,columnproperty(OBJECT_ID(TABLE_NAME),   COLUMN_NAME, 'IsIdentity') as IsIdentity,ORDINAL_POSITION, IS_NULLABLE, DATA_TYPE, CHARACTER_OCTET_LENGTH, NUMERIC_PRECISION, COLLATION_NAME, CHARACTER_SET_NAME FROM INFORMATION_SCHEMA.COLUMNS    WHERE TABLE_NAME = 'your_table_name'ORDER BY TABLE_NAME, ORDINAL_POSITION, COLUMN_NAME