sql server查看表结构

SELECT 
    COLUMN_NAME = c.name,
    DATA_TYPE = t.name,
    COLUMN_COMMENT = ISNULL(ep.[value], '')
FROM 
    sys.columns c
INNER JOIN 
    sys.tables t1 ON c.object_id = t1.object_id
INNER JOIN 
    sys.types t ON c.system_type_id = t.system_type_id
LEFT JOIN 
    sys.extended_properties ep ON c.object_id = ep.major_id 
                                AND c.column_id = ep.minor_id
                                AND ep.name = 'MS_Description'
WHERE 
    t1.name = 'TableName'  -- 请替换为你要查询的表名
ORDER BY 
    c.column_id;