查询某表所有列名的SQL语句
select name
from syscolumns
where id=(
select max(id) from sysobjects where xtype='u' and name='表名'
)
order by colorder
select name
from syscolumns
where id=(
select max(id) from sysobjects where xtype='u' and name='表名'
)
order by colorder