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

select name

from syscolumns

where id=(

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

                )

order by colorder

posted @ 2008-06-17 11:47  my favorite  阅读(890)  评论(0编辑  收藏  举报