select name from syscolumns where id= object_id('table')
select * from table where 1=2 这样?
create table [table](id int,name varchar(10),price dec(18,2),quantity int)select * from [table] where 1=2 /** id name price quantity ----------- ---------- -------------------- ----------- **/select name from syscolumns where id= object_id('table') /** name ----------------------------------------------------------- id name price quantity **/
--SQL 2005: select name from sys.syscolumns where id= object_id('表名')--SQL2000: select name from syscolumns where id= object_id('表名')
SELECT COL_NAME(OBJECT_ID('表名'), 索引) AS 'Column Name';索引 从1开始,
select name from syscolumns where id= object_id('table')
这样?
/**
id name price quantity
----------- ---------- -------------------- -----------
**/select name from syscolumns where id= object_id('table')
/**
name
-----------------------------------------------------------
id
name
price
quantity
**/
--SQL 2005:
select name from sys.syscolumns where id= object_id('表名')--SQL2000:
select name from syscolumns where id= object_id('表名')
SELECT COL_NAME(OBJECT_ID('表名'), 索引) AS 'Column Name';索引 从1开始,