Find number of tables in Db2 database

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

Comments are only visible when the visitor has consented to statistics cookies. To see and add comments please accept statistics cookies.
0
There are no comments. Click here to write the first comment.