查询用户表
select * from dbo.sysobjects where xtype = 'U'
查询表结构:
select a.name as colName,a.length,c.name as type,b.name as tableName from dbo.syscolumns as a
inner join dbo.sysobjects as b on b.id = a.id
inner join dbo.systypes as c on a.xtype = c.xtype
where b.xtype = 'U'