摘要: 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... 阅读全文
posted @ 2013-02-25 10:49 伊广源 阅读(601) 评论(0) 推荐(0) 编辑