viewing design of the database

[portagal]

Hi,
I have cataloged a remote database, and now i need to know the overall design of the database (table schemas, the relation between tables and views,...) Is there any way to do this other than going to control center and selecting "show related" on context menu of specific table/view.

thank you all in advance

 

[rbod]

select substr(tabname,1,20) table_name,substr(constname,1,20) fk_name,fk_colnames,substr(REFTABNAME,1,12) parent_table,substr(refkeyname,1,20) parent_pk
from syscat.references
where tabname like 'TABLE_NAME'

 

[portagal]

Thanks rbod for your help, but for this query i get 0 record selected for tables in my db. Is there any resources online that i can read and find out more about syscat.references.

Thank u,

 

[rbod]

If you want to see for all the tables, remove the where clause from the query.

http://publib.boulder.ibm.com/infoc...topic=/com.ibm.db2.udb.doc/admin/r0001057.htm