select Columns,Tables

最新推荐文章于 2024-08-28 23:59:13 发布

原创最新推荐文章于 2024-08-28 23:59:13 发布 · 589 阅读

0 ·

CC 4.0 BY-SA版权

文章标签：

#join #c

本文介绍了一个SQL查询语句，该语句用于获取数据库中所有用户表的详细结构信息，包括表名、列名、数据类型、长度、是否允许为空及列的描述。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

SELECT TOP 100 PERCENT c.colid AS 序号, o.name AS 表名, c.name AS 列名,
      t.name AS 类型, c.length AS 长度, c.isnullable AS 允许空,
      CAST(m.[value] AS Varchar(100)) AS 说明
FROM dbo.syscolumns c INNER JOIN
      dbo.sysobjects o ON o.id = c.id AND objectproperty(o.id, N'IsUserTable') = 1 AND
      o.name <> 'dtproperties' INNER JOIN
      dbo.systypes t ON t.xusertype = c.xusertype LEFT OUTER JOIN
dbo.sysproperties m ON m.id = o.id AND m.smallid = c.colorder
ORDER BY o.name, c.colid