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.