describe table

amanriquem · #1 (**permalink**) 09-23-06, 12:49

Hi, is there a sentence in db2 as400 that shows a table structure like "desc <table>" in Oracle?

thanks in advance.

przytula_guy · #2 (**permalink**) 09-24-06, 03:03

I don't know for as/400 interface, but when using any client and being connected to the as/400 db you can execute : db2 describe table xx.yyy

Wim · #3 (**permalink**) 09-25-06, 03:51

You can get the full DDL's to recreate an (empty) clone of a database with
db2look. It return the create table, create view, FK's, PK's, constraints, ... scripts.

jinsezh · #4 (**permalink**) 09-25-06, 19:48

In command editor, you can use "Describe select * from table"

Or if you just want to know the column name, you can use
"select * from table where 1=2", that will just return the column names.

Internet Services

Web Development

Digital Marketing

Consumer Tech