取 SQL SERVER 字段信息

iteye_7530

于 2010-12-28 16:50:35 发布

阅读量141

点赞数

CC 4.0 BY-SA版权

分类专栏：数据库文章标签： SQL Server SQL C C++ C#

本文链接：https://blog.youkuaiyun.com/iteye_7530/article/details/81993946

数据库专栏收录该内容

16 篇文章

订阅专栏

本文提供了一种使用SQL查询特定表结构的方法，包括字段名、数据类型等关键信息，并展示了如何通过联合多个系统表来获取所需的数据。

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

SELECT A.NAME AS '字段',B.NAME AS '类型',A.LENGTH AS '长度',
        CASE WHEN A.ISNULLABLE = 1 THEN 'NULL' ELSE 'NOT NULL' END AS '是否为空'
 FROM SYSOBJECTS AS C 
 LEFT JOIN SYSCOLUMNS AS A ON C.ID = A.ID
 LEFT JOIN SYSTYPES B ON A.XTYPE = B.XTYPE 
     WHERE C.NAME = '所在表名';



Select a.name AS 字段名, b.name AS 类型
FROM syscolumns a INNER JOIN
      systypes b ON a.xusertype = b.xusertype INNER JOIN
      sysobjects d ON a.id = d.id AND d.xtype = 'U' AND d.name <> 'dtproperties'
Where (d.name = '表名')
ORDER BY a.id