SQLServer查询表结构信息代码

最新推荐文章于 2023-04-19 09:19:36 发布

wu_man_xin

最新推荐文章于 2023-04-19 09:19:36 发布

阅读量649

点赞数

文章标签： sqlserver 数据库 sql

本文链接：https://blog.csdn.net/wu_man_xin/article/details/126544309

版权

SELECT cast(A.NAME as nvarchar)    as column_name,
       cast(B.NAME as nvarchar)    as data_type,
       cast(G.[VALUE] as nvarchar) as column_comment
FROM SYSCOLUMNS A
         LEFT JOIN SYSTYPES B ON A.XTYPE = B.XUSERTYPE
         INNER JOIN SYSOBJECTS D ON A.ID = D.ID AND D.XTYPE = 'U' AND D.NAME != 'DTPROPERTIES'
         LEFT JOIN SYS.EXTENDED_PROPERTIES G ON A.ID = G.MAJOR_ID AND A.COLID = G.MINOR_ID
         LEFT JOIN SYS.EXTENDED_PROPERTIES F ON D.ID = F.MAJOR_ID AND F.MINOR_ID = 0
where D.NAME = 表名
ORDER BY A.COLORDER