CrazyEngineers Logo

What is the command to list the table names in db2

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?

Replies

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

    Try this one:
    "select * from syscat.tables"
  • ms_cs
    ms_cs
    Thank you .It worked
  • rajagiri2
    rajagiri2
    no idea.
    [​IMG]

You are reading an archived discussion.

Related Posts

Suggest prizes for our competitions

CEans, CE will be organizing contests in near future and seeks your feedback on prizes we can have for the contests. The budget for the prize(s) would be about $200.

World Environment Day

World Environment Day (WED) was established by the UN General Assembly in 1972 to mark the opening of the Stockholm Conference on the Human Environment. WED is Commemorated yearly on...

ME here

Well, almost. I never did get that second, as they call it. But I'm a hobbyist from way back. What got me into electronics was a project I had my...

Compare M.Tech. (in India) and MS(in US) !!

hai i`m doing my 3rd Btech and my branch of study is ECE. Now i`m in a dilemma to choose my career. In acutal, i`m a bit intrested in the...

an intelligent ambulence car which controll to traffic light

i want ideas about traffic light control ambulance👍