Skip to Content
0
Oct 21, 2022 at 05:27 AM

How to find RECORD_COUNT of collection table . TABLE_TYPE = 'COLLECTION' in Hana DB?

495 Views

Hi Team,

SELECT RECORD_COUNT FROM M_TABLES WHERE TABLE_TYPE = 'COLLECTION';

This always gives NULL.

we have many collection tables in a schema , where we store json objects in collection tables. we need to find the count of all json objects stored in a schema. is there any way.

At collection table level i get count by

SELECT count(*) FROM "my_Collecttion_table_name_1";--2 ROWS

SELECT count(*) FROM "my_Collecttion_table_name_2";--10 ROWS

SELECT count(*) FROM "my_Collecttion_table_name_3";--20 ROWS

I need to get 32 row count info at schema level. how can I get this ?

SELECT sum(RECORD_COUNT) FROM M_TABLES WHERE TABLE_TYPE = 'COLLECTION' and TABLE_NAME LIKE '%_name_%';

This always gives NULL.