How can I view all table names in db2?

2 years ago

Isabella Edwards

1 minute

In DB2 database, you can use the following SQL statement to view all table names:

SELECT TABNAME FROM SYSCAT.TABLES

This SQL statement will retrieve the names of all tables in the database. Alternatively, you can use other criteria to filter the desired table names, such as viewing only the table names under a specific schema.

SELECT TABNAME FROM SYSCAT.TABLES WHERE TABSCHEMA = 'your_schema'