Instead of your query, I would recommend using query from INFORMATION_SCHEMA.Tables table
SELECT TABLE_SCHEMA, TABLE_NAME, CLASSNAME FROM INFORMATION_SCHEMA.Tables
In Cache we don't have a table with the number of rows in each table, you have to measure it by yourself for each table. But you can write SQL Function which will count it for you, and you can use this function in the query above.
SELECT count(*) FROM Sample.Person
- Log in to post comments

