0 - 4 of 4 tags for #ROWCOUNT

Hi,
I have the following SQL query for this I need to find a count of the rows
 
SELECT COL1,COL2,COL3
FROM SCHEMA.TABLE1
WHERE COL1 IN ('A','B') AND COL2 IN (SELECT COL2 FROM SCHEMA.TABLE2)

Hello All,
I faced one scenario where I couldn't find any solution.
Let's take an example. 100 Tables are there in a database. How to know the row counts for all the 100 tables in this database.
 
Regards,
Abhi

Hello !
Is it possible to check any View/Table in Teradata to find Row counts of all tables in a Database?
If not, how to get the same?

Hi,
I am trying to compare the row count of table in two different databases but the tables are similar with same DDL. I need to call table name in cursor and database names are parameters of the procedure.  
Replace procedure testProc(a varchar(30),b varchar(30))
BEGIN
-- Cursor is having the names of table in order