var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: Find PrimaryKey Columns...
can anybody tell me how to find out which columns are member of the primary key from any table in a DB2 database?
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.
Thank you! Did found it in the DB2 catalog tables/views.
Last edited by VitaminB; 05-22-06 at 06:34.