regarding getting row count by not using dba_tables , tab,ALL_TABLES
83030
Get counts of all tables in a schema
54340
How to check for existence of an INDEX on a column independent of used SQL database
37605
How to output result of SELECT statement which is executed using native dynamic SQL?
148599
"Column count doesn't match value count at row" but it does
67025
How to convert row values to columns with dynamic columns count?
83063
Count(*) vs Count(1) - SQL Server
27437
Get list of all tables in Oracle?
52343
How to include the total number of returned rows in the resultset from SELECT T-SQL command?
132138
how to count dates entries monthwise from a resultset
83242
How to get count for different columns on same table
67735
How can I find which tables reference a given table in Oracle SQL Developer?
120734
How to get Total Pupulation From Tables In Sqlserver?
8924
How do I see all foreign keys to a table or column?
96901
How to list of all the tables defined for the database when using active record?
27912
How do I get list of all tables in a database using TSQL?
98347
SQL Server Row by Row Access
158997
In MS SQL how do I find out what tables have not been queried or updated in a long time?