查询某表所有列名的SQL语句

select name

from syscolumns

where id=(

                  select max(id) from sysobjects where xtype='u' and name='表名'

                )

order by colorder