SQLServer 中快速查询出用户表,系统表的sql语句
select * from sysobjects where? type ='U'--查询用户表
select * from sysobjects where? type = 'v'--查询试图
?
select * from sysobjects where? type = 's'--查询系统表
发布时间: 2012-07-04 19:33:55 作者: rapoo
SQLServer 中快速查询出用户表,系统表的sql语句
select * from sysobjects where? type ='U'--查询用户表
select * from sysobjects where? type = 'v'--查询试图
?
select * from sysobjects where? type = 's'--查询系统表