Implementing DB2 tables

Use the columns and rows of DB2® tables as logical structures for storing data.

Creating base tables
When you create a table, DB2 records a definition of the table in the DB2 catalog.
Guidelines for table names
Most organizations have naming conventions to ensure that objects are named in a consistent manner. Consider these basic requirements for table names.
Creating tables that use hash organization
When you create a table, you can organize the table by hash to improve the performance queries that access individual rows.
Creating temporary tables
Temporary tables are useful when you need to sort or query intermediate result tables that contain large numbers of rows and identify a small subset of rows to store permanently. The two types of temporary tables are created temporary tables and declared temporary tables.
Creating temporal tables
You can create a temporal table, which is a table that records the period of time when a row is valid.
Creating materialized query tables
Materialized query tables improve the performance of complex queries that operate on very large amounts of data. Use the CREATE TABLE statement to create a materialized query table.
Creating tables that use table-controlled partitioning
Table-controlled partitioning does not require an index for partitioning and is defined by PARTITION clauses on the CREATE TABLE statement.
Creating tables that use index-controlled partitioning
Tables that use index-controlled partitioning require a partitioning index. Because the index is created separately from the associated table, you cannot insert data into the table until the partitioning index is created.
Creating a clone table
You can create a clone table on an existing base table at the current server by using the ALTER TABLE statement.

Parent topic: Implementing your database design

Related concepts:

Creation of tables

Related tasks:

Creating tables

Related reference:

CREATE TABLE