db2 list of tables

kotha · #1 (**permalink**) 12-19-08, 20:10

would like to get a list of tables available in a given DB2. can some one help me ? new to databases

tonkuma · #2 (**permalink**) 12-19-08, 20:47

Code:

------------------------------ Commands Entered ------------------------------
list tables for all;
------------------------------------------------------------------------------
list tables for all

Table/View                      Schema          Type  Creation time
------------------------------- --------------- ----- --------------------------
EXPLAIN_ARGUMENT                DB2ADMIN        T     2008-12-18-06.49.16.419001
EXPLAIN_DIAGNOSTIC              DB2ADMIN        T     2008-12-18-06.49.19.163000

(snipped)

TABLES                          SYSSTAT         V     2008-10-13-16.49.07.231000
HMON_ATM_INFO                   SYSTOOLS        T     2008-10-13-18.34.01.362001
HMON_COLLECTION                 SYSTOOLS        T     2008-10-13-18.34.03.585001
POLICY                          SYSTOOLS        T     2008-10-13-18.33.54.913001

  393 record(s) selected.

tonkuma · #3 (**permalink**) 12-19-08, 20:51

For another options, please see the manual.

Command Reference for Linux, UNIX, and Windows DB2 Version 9
Chapter 3. CLP Commands
LIST PACKAGES/TABLES

Marcus_A · #4 (**permalink**) 12-19-08, 20:59

You can also write a select statement againt the syscat.tables view. See the SQL Reference Vol 1 Appendix for details on what is in the Catalog Tables.

nick.ncs · #5 (**permalink**) 12-19-08, 21:55

I go to Google and I type "list tables db2".... and lo behold I have my answers.... why do people still take the pains to come and register and then post such questions when it takes less time to google for it....

stolze · #6 (**permalink**) 12-21-08, 08:00

hmm.... maybe because Google is too complicated for them?

Internet Services

Web Development

Digital Marketing

Consumer Tech