select [name] from syscolumns where id=object_id('表名') order by colid
SELECT syscolumns.name AS 列名, systypes.name AS 数据类型, syscolumns.length AS 长度 FROM sysobjects INNER JOIN syscolumns ON sysobjects.id = syscolumns.id LEFT JOIN systypes ON syscolumns.xtype = systypes.xtype WHERE sysobjects.name = 表名 and systypes.name <> 'sysname'仅供参考,有侍完善
SELECT syscolumns.name AS 列名, systypes.name AS 数据类型, syscolumns.length AS 长度
FROM sysobjects INNER JOIN syscolumns
ON sysobjects.id = syscolumns.id
LEFT JOIN systypes
ON syscolumns.xtype = systypes.xtype
WHERE sysobjects.name = 表名 and systypes.name <> 'sysname'仅供参考,有侍完善