查询一个表的某一个列的属性

最新推荐文章于 2022-07-04 13:09:27 发布

原创最新推荐文章于 2022-07-04 13:09:27 发布 · 1k 阅读

0 ·

CC 4.0 BY-SA版权

文章标签：

#join #c

本文介绍如何使用SQL查询语句SELECT TOP 100 PERCENT结合JOIN操作，从系统元数据表中获取指定表及其指定列的详细信息，包括序号、表名、列名、类型、长度和是否允许为空等属性。

SELECT TOP 100 PERCENT c.colid AS 序号, o.name AS 表名, c.name AS 列名,
      t.name AS 类型, c.length AS 长度, c.isnullable 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
      where o.name = '表名' and c.name = '列名'
ORDER BY o.name, c.colid