摘要:
SQL中统计表的个数:SELECT count(*) FROM sysobjects WHERE XType='U' //表个数SELECT count(*) FROM sysobjects WHERE XType= 'V' //视图个数SELECT count(*) FROM sysobjects WHERE XType= 'P' //存储过程个数SQL获得表名:SELECT name FROM sysobjects WHERE XTYPE='U' ORCALE中统计数据表的总个数:SEL... 阅读全文