That is in the DB2 Commands book under DISPLAY for an easier way.
Or a simple SQL SELECT * FROM SYSIBM.SYSTABLES WHERE DBNAME ??? There are many examples on the internet for this function. But perhaps you have a more specific requirement. If so, let us know so we can help. Lizette -----Original Message----- >From: Micheal Butz <[email protected]> >Sent: Apr 4, 2011 10:29 AM >To: [email protected] >Subject: DB2 Tables In a database > >Hi, > >Would anyone know the SQL statement to list all the tables in a database > > >Thanks > >Sent from my iPhone > >---------------------------------------------------------------------- >For IBM-MAIN subscribe / signoff / archive access instructions, >send email to [email protected] with the message: GET IBM-MAIN INFO >Search the archives at http://bama.ua.edu/archives/ibm-main.html ---------------------------------------------------------------------- For IBM-MAIN subscribe / signoff / archive access instructions, send email to [email protected] with the message: GET IBM-MAIN INFO Search the archives at http://bama.ua.edu/archives/ibm-main.html
