sqlserver查询表结构

SELECT
tab.name AS tableName,
col.name AS column_name,
per.value AS column_comment,
col.is_identity AS column_key,
type.name AS data_type,
col.max_length AS column_length
FROM
sys.columns col
INNER JOIN sys.tables tab ON col.object_id = tab.object_id
LEFT JOIN sys.extended_properties per ON col.column_id = per.minor_id
AND per.major_id = tab.object_id
INNER JOIN sys.types type ON col.user_type_id = type.user_type_id
WHERE tab.name = ‘CRM_HouseInfo’
ORDER BY
tab.name,
col.is_identity DESC;