Creating a table using the Create Table wizard - IBM DB2 9.7 for Linux, UNIX, and Windows

Use the Create Table wizard to create new tables in a database. Name the table, determine the columns that you want, and specify the space needed for storing the table data. You can continue by making selections about keys, dimensions, and constraints.

Before you begin

To create a table, you must have at least one of the following privileges:

CREATETAB privilege on the database and USE privilege on the table space, and either:
- IMPLICIT_SCHEMA authority on the database if the implicit or explicit schema name of the table does not exist
- CREATEIN privilege on the schema if the schema name of the table exists
DBADM authority

Procedure

Open the Create Table wizard: From the Control Center, expand the object tree until you find the Tables folder. Right-click the Tables folder and select Create from the pop-up menu. The Create Table wizard opens.
Complete each of the applicable wizard pages. Click the wizard overview link on the first page for more information. The Finish push button is enabled when you specify enough information for the wizard to create a table.