devxlogo

Obtain Information About Table Columns in Microsoft SQL Server

Obtain Information About Table Columns in Microsoft SQL Server

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

devx-admin

Share the Post: