SELECT name FROM sys.columns WHERE object_id = OBJECT_ID('要查询的表名');注意,表名前后有单引号,是字符串。
select * from table where 1=2