获取数据库表名：

select * from sysobjects where xtype='U'and name<>'dtproperties'

Order By Name

Select ID From SYSOBJECTS Where ID=OBJECT_ID('pub_SysPara')

select * from sysobjects where name ='pub_SysPara' AND xtype='u'

获取数据库表字段名： 

select c.name ,a.name,t.name,a.length,a.prec

from syscolumns a

inner join sysobjects c ON

a.id=c.id AND c.xtype='U' inner join systypes t ON a.xtype=t.xtype Order By c.name