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