SELECT TOP 0 * FROM TB 或者 SELECT * FROM TB WHERE 1=2
得到表中的所有列信息(包含数据类型名):SELECT syscolumns.name,systypes.name,syscolumns.isnullable,syscolumns.length FROM syscolumns, systypes WHERE syscolumns.xusertype = systypes.xusertype AND "syscolumns.id = object_id('tableName')
from 表名
where 1<>1
或者
SELECT * FROM TB WHERE 1=2
得到表中的所有列信息(包含数据类型名):SELECT syscolumns.name,systypes.name,syscolumns.isnullable,syscolumns.length
FROM syscolumns, systypes
WHERE syscolumns.xusertype = systypes.xusertype AND "syscolumns.id = object_id('tableName')