how to see DDL for an existing table/view

[portagal]

I wonder if there is any way to find out about the defenition of a table, I have some tables and views which are based on other tables and views on different databases I need to see how they have been defined.
I am very new in DB2 actually in databases, so i appriciate any help.

thanks

 

[juliane26]

check out db2look utility.

e.g. db2look -d dbname -e

just entering
>db2look
shows you all the options.

(I guess you are not asking about the host ...)

Juliane

 

[DBAJr]

For individual tables, use command:
describe table table-name

 

[BrianTyler]

db2look -e -d datbasename -z db2prod -tw tablerequired -i myusername -w mypassword -a

This will show the full ddl for the table