Obtain Information About Table Columns in Microsoft SQL Server

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