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语句