Find number of tables in Vertica database

Query below returns total number of tables in current database.


select count(*) as tables
from v_catalog.tables;


  • tables - number of tables in a database


Query returns just one row.

Sample results

Those results show that there are 16 tables in VMart database.

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