select id from sysobjects where name='titles'
select [name],* from syscolumns where id=(select id from sysobjects where name='titles') order by colid

sqlserver查询系统表和系统表的字段的sql语句

posted on 2010-07-10 11:11  bestsaler  阅读(1102)  评论(0编辑  收藏  举报