1 SELECT 2    col.name AS 列名, 3    typ.name as 数据类型, 4    col.max_length AS 占用字节数, 5    col.precision AS 数字长度, 6    col.scale AS 小数位数, 7    col.is_nullable  AS 是否允许非空, 8    col.is_identity  AS 是否自增, 9    case when exists 10       ( SELECT 1 11         FROM 12           sys.indexes idx 13             join sys.index_columns idxCol 14             on (idx.object_id = idxCol.object_id)15          WHERE16             idx.object_id = col.object_id17             AND idxCol.index_column_id = col.column_id18             AND idx.is_primary_key = 119        ) THEN 1 ELSE 0 END  AS 是否是主键,20   isnull(prop.[value],‘-‘) AS 说明21 FROM22   sys.columns col 23     left join sys.types typ 24       on (col.system_type_id = typ.system_type_id)25     left join sys.extended_properties prop26       on (col.object_id = prop.major_id AND prop.minor_id = col.column_id)27 WHERE28   col.object_id =29     (SELECT object_id FROM sys.tables WHERE name = ‘band‘)