查询某个库的所有表名
select * from sysobjects where type='u'
select * from information_schema.tables
某个表的的有字段
select * from syscolumns where id=object_id('ssq')
某个表的字段和备注
select syscolumns.[name],syscolumns.[id],sysproperties.[value]
from syscolumns
left join sysproperties on
syscolumns.[id]=sysproperties.[id]
and syscolumns.[colid]=sysproperties.[smallid]
where syscolumns.id=object_id('ssq')
order by syscolumns.[colid]