What is the command to list the table names in db2

ms_cs

ms_cs

@ms-cs-Ab8svl • Oct 19, 2024

I am new to DB2.
In SQL we can list table names using select * from tab;
What is the command to list the table names in db2 database?

Like 0 Replies 3

Replies

Welcome, guest

Join CrazyEngineers to reply, ask questions, and participate in conversations.

Sign up Log in

CrazyEngineers powered by Jatra Community Platform

  • shalini_goel14

    shalini_goel14

    @shalini-goel14-ASmC2J • Jun 3, 2009

    I guess syscat.tables would work. All tables are stored there

    Try this one:
    "select * from syscat.tables"

    0
  • ms_cs

    ms_cs

    @ms-cs-Ab8svl • Jun 3, 2009

    Thank you .It worked

    0
  • rajagiri2

    rajagiri2

    @rajagiri2-uSk5rf • Jun 3, 2009

    no idea.
    [​IMG]

    0