Defining table properties when creating a table

Use the Table page of the Create Table notebook to define the table properties.

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.

To define table properties:

1. Open the Create Table notebook.

2. Use the Table schema box to specify the schema for the table that you're creating.

3. In the Table name field, type a name for the table that you're creating.

4. Optional: Use the Table space box to specify the table space in which to create the table.

5. Optional: Use the Index table space box to specify the table space in which to create any indexes on the table.

6. Optional: Use the Long data table space box to specify the table space in which to store the values of any long columns.

7. Optional: In the Comment field, document the table that you're creating.

8. If you plan to use this table for replication, select the Data capture for propagation check box.

9. Optional: If you want to duplicate all of the table data on each database partition of the nodegroup of the table, select the Duplicate table data on each database partition check box.

10. Continue on to the Columns page.

Related information

• Table schema and name -- See the SQL Reference
• More about schemas
• Replication -- See the Replication Guide
• Adding columns when creating a table
• Selecting predefined columns when creating a table
• Editing column lists when creating a table
• Defining the primary key when creating a table
• Adding foreign keys when creating a table
• Defining the partitioning key when creating a table
• Adding check constraints when creating a table

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

[ DB2 List of Books | Search the DB2 Books ]