To get the number of rows in all tables in Oracle database, use this query.
SELECT table_name,num_rows FROM all_tables WHERE owner = 'SCHEMA';
Table and its count To view all tables and its count by executing command and immediately, use below commands - MSSQL SELECT sc. name + '.' + ta. name TableName, SUM (pa. rows ) RowCnt FROM sys.tables ta INNER JOIN sys.partitions pa ON pa.OBJECT_ID = ta.OBJECT_ID INNER JOIN sys.schemas sc ON ta.schema_id = sc.schema_id WHERE ta.is_ms_shipped = 0 AND pa.index_id IN (1,0) GROUP BY sc. name ,ta. name ORDER BY SUM (pa. rows ) DESC
Comments
Post a Comment