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