select
(
select
count
(
*
)
as
用户数据表
from
数据库名.dbo.sysobjects
where
xtype
=
'
u
'
and
status
>=
0
)
as
用户数据表, (
select
count
(
*
)
as
用户存储过程
from
数据库名.dbo.sysobjects
where
xtype
=
'
P
'
and
status
>=
0
)
as
用户存储过程, (
select
count
(
*
)
as
用户视图
from
数据库名.dbo.sysobjects
where
xtype
=
'
V
'
and
status
>=
0
)
as
用户视图, (
select
count
(
*
)
as
触发器
from
数据库名.dbo.sysobjects
where
xtype
=
'
TR
'
and
status
>=
0
)
as
触发器
在网友feixue那摘的,免得忘了。
扫一扫
1855
被折叠的 条评论
为什么被折叠?
到【灌水乐园】发言
