IBM Mainframe Forum • DB2 Tables In a database - DB2

Page 1 of 1

DB2 Tables In a database

Posted: Mon Apr 04, 2011 8:07 pm

by jaggz

Hi,

Would anyone know the SQL statement to list all the tables in a database.

Re: DB2 Tables In a database

Posted: Mon Apr 04, 2011 8:36 pm

by Akatsukami

jaggz wrote:Hi,

Would anyone know the SQL statement to list all the tables in a database.

SELECT * FROM SYSIBM.SYSTABLES
WHERE DBNAME='database-name'

Re: DB2 Tables In a database

Posted: Mon Apr 04, 2011 8:59 pm

by MrH

Or, after establishing a database connection: LIST TABLES FOR ALL