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