Creating a table

Use the Create Table notebook to create a table. When you create a table, DB2 for OS/390 records a definition of the table in the DB2 for OS/390 catalog.

Authorities and privileges

To create a table:

1. Open the Create Table notebook.
2. On the Table page, define the table properties.
3. On the Columns page, click Add and add columns using the Add Column notebook.
4. Optional: On the Primary Key page, define the primary key.
5. Optional: On the Unique Key page, click Add and define unique keys using the Add Unique Key window.
6. Optional: On the Foreign Key page, click Add and add foreign keys using the Add Foreign Key window.
7. Optional: On the Check Constraints page, click Add and add check constraints using the Add Check Constraints window.
8. Click OK to create your table and close the Create Table notebook.

Related information

• Altering a table
• Creating an index