列出sql数据表的各列的sql语句--sunshine的Blog

列出sql数据表的各列的sql语句

[ 2007-6-14 17:09:00 | By: sunshine ]

SELECT syscolumns.name, systypes.name AS columtype, syscolumns.length
FROM syscolumns INNER JOIN
systypes ON syscolumns.xtype = systypes.xtype
WHERE (syscolumns.id = OBJECT_ID('你的表名'))