Creating a primary key for a table

A primary key of a table can be used for linking the table to another table.
Before you begin
About this task
To create a primary key for a table:
  1. Start IBM® InfoSphere™ Data Architect and load the data model.
  2. Expand the table where you want to add the primary key and select the column that you want to designate as the primary key.
  3. In the Properties view, click the Type tab.
  4. Select Primary key.
  5. In the Project Explorer view, right-click the table where you added the primary key and click Generate DDL.
  6. Make sure to select the following options: Fully qualified names, CREATE statements, COMMENT ON statements, and IN TABLESPACE clause.
  7. Click Next.
  8. Make sure to select the following options: Check constraint, Foreign key constraint, Primary key constraint, and Tables.
  9. Click Next.
  10. Select Run DDL on server, click Next, select the data warehouse connection, and click Next.
  11. When prompted, type the user name and password for the database connection.
  12. Click Finish.

Feedback