Creating a table

Use the Create Table notebook to create a table.

You can also use a SmartGuide to create a table.

The Create Table notebook is for defining a table. If you want to create a table and populate it with an input file, use the Import function instead.

Before you begin...

To create a table:

1. Open the Create Table notebook.

2. Define the table properties.

3. Add the columns.

4. Optional: Define the primary key.

5. Optional: Define the partitioning key.

6. Optional: Add the foreign keys.

7. Optional: Add the check constraints.

Page controls

• Table
• Columns
• Primary Key
• Partitioning Key
• Foreign Keys
• Check Constraints

Controls

• OK
• Cancel

Related information

• Adding table privileges
• Adding table triggers
• Altering a table
• Creating a view
• Creating an index

[ Top of Page | Table of Contents | Glossary | Index ]

[ DB2 List of Books | Search the DB2 Books ]