Thursday, March 01, 2007

Showing a Table's Foreign Keys with DB2 Control Centre

Might be obvious to some. Not to me...

  1. Start Control Centre and connect to your database
  2. Select "Tables" for your database from the tree in the left hand panel
  3. Right click on the table you are interested in in the tables panel on the right hand side and select the "Alter Table" option
  4. Select the "Keys" tab in the new window and voila.

No comments: