Query to list all tables in a schema I am using Rational Application Developer to run querys on a database. We are unable to locate anyone who has a list of the tables on the schema and so far the queries we have found to get a list of tables are unsuccessful.

USE &lt;DB&gt;
GO
SELECT *
FROM sys.Tables
GO


Use breaks but I replaced it with CALL.

GO breaks as well and I cannot locate a function that does the same thing.
The given statement smells like MS SQL-Server, not like DB2.

According to IBM Documentation I think SYSCAT.TABLES is the view you are looking for.