SQL server 2016 读取表结构

SELECT
    c.name field,
    e.value display_name,
    t.name type,
    c.max_length length,
    c.is_nullable
FROM
    sysobjects b
    LEFT JOIN sys.columns c ON c.object_id = b.id
    LEFT JOIN sys.types t ON t.system_type_id= c.system_type_id AND t.user_type_id = c.user_type_id
    LEFT JOIN sys.extended_properties e ON e.major_id = b.id 
    AND minor_id = c.column_id 
WHERE
    b.name = '表名'