select id from sysobjects where name='titles'select [name],* from syscolumns where id=(select id from sysobjects where name='titles') order by colid
sqlserver查詢系統(tǒng)表和系統(tǒng)表的字段的sql語句