Hi Guys,

can anybody tell me how to find out which columns are member of the primary key from any table in a DB2 database?

Thanks,
Marc

One way to do this is to use db2look utility...

db2look -d test -e -a -t employee -o employee.ddl

Where 'test' is the database name & 'employee' is the table name.

The output file employee.ddl will have the DDL for employee table which will also have the primary key SQL statement.

You can also use the syscat.keycoluse catalog table to get this information.

HTH.

Thank you! Did found it in the DB2 catalog tables/views.

Regards,
Marc