SQL Server Query table structure, field, type, length, description information all have

SelectSys.columns.name asField name, Sys.types.name asfield type, Sys.columns.max_length asLength, sys.columns.is_nullable asis nullable, (SelectCount(*) fromSys.identity_columnswhereSys.identity_columns.object_id=Sys.columns.object_id andsys.columns.column_id=SYS.IDENTITY_COLUMNS.COLUMN_ID) aswhether self-growth, (SelectValue fromSys.extended_propertieswheresys.extended_properties.major_id=Sys.columns.object_id andsys.extended_properties.minor_id=SYS.COLUMNS.COLUMN_ID) asDescription fromSys.columns, Sys.tables, sys.typeswhereSys.columns.object_id=Sys.tables.object_id andsys.columns.system_type_id=sys.types.system_type_id andSys.tables.name='TableName' Order bysys.columns.column_id

View Code