sqlserver,oracle,cache,mysql等各类数据基础查询 sql server 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'