查询数据库中有多少表、视图、存储过程

sql server:
表: select count(1) from sysobjects where xtype='U' 
视图: select count(1) from sysobjects where xtype='V'
存储过程: select count(1) from sysobjects where xtype='P'
posted @ 2014-03-24 15:00  Mander_Gao  阅读(270)  评论(0编辑  收藏  举报