DB2 create tabel statements are well understood. However, the following section does not describe the general usage of DB2 create tabel statements. If you are interested, take a look.
The general DB2 create tabel statement is not mentioned. Let's talk about three advanced DB2 create tabel statements:
1. Create a result table
Create table new_table_name
(Select * from table_name) definition only;
2. Create a materialized query table MQT)
Create table new_table_name
(Select * from table_name)
Data initially deferred refresh deferred;
Refresh table new_table_name;
Note: A materialized table is similar to a Query. the type of the table is displayed as Query. But it can be used as a table.
3. Copy the table structure
Create table new_table_name like table_name;
Overview of DB2 Flow Control clauses
Principle of DB2 cursor
Two ways to store db2 logs
Common DB2 cycle usage
DB2 Directory structure