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

select name

from syscolumns

where id=(

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

                )

order by colorder

转载于:https://www.cnblogs.com/hdjjun/archive/2008/06/17/1223695.html