常用的表查询MSSQL语句
select * from 库名..sysobjects where xtype='U' ---用户表
select * from 库名..sysobjects where xtype='s' ---系统表
select * from 库名..sysobjects where xtype='v' ---视图
select * from 库名..sysobjects where xtype='p' ---存储过程
select * from 库名..sysobjects where xtype='s' ---系统表
select * from 库名..sysobjects where xtype='v' ---视图
select * from 库名..sysobjects where xtype='p' ---存储过程
