Query below returns total number of tables in current database.

Query

select count(*) as tables
from syscat.tables t
where t.type = 'T' 

Columns

• tables - number of tables in a database

Rows

• Query returns just one row

Sample results