来源:http://news.mkq.online/ 作者:牛站新闻
MSSQL中统计表的个数:
SELECT count() FROM sysobjects WHERE (xtype = ‘U’)//表个数
SELECT count() FROM sysobjects WHERE (xtype = ‘V’)//视图个数
SELECT count(*) FROM sysobjects WHERE (xtype = ‘P’)//存储过程个数
MSSQL获得表名:
SELECT name FROM sys.object WHERE (xtype = ‘U’)
ORCALE中统计数据表的总个数:
SELECT count(*) FROM dba_tables WHERE (owner=‘用户名’)————有DBA权限
SELECT count(*) FROM all_tables WHERE (owner=‘用户名’)————普通用户权限
ORCALE获得表名:
SELECT name FROM dba_tables WHERE (owner=‘用户名’)
SELECT name FROM all_tables WHERE (owner=‘用户名’)