Three advanced usage of select statements in DB2 database

1. Create a result table

 
  
  


   
   
Create TableNew_table_nameAs

   
   
 

   
   
(Select*FromTable_name) DefinitionOnly;

  
  
 

2. Create a materialized query table (MQT)

  
  


   
   
Create TableNew_table_nameAs

   
   
 

   
   
(Select*FromTable_name)

   
   
 

   
   
Data initially deferred refresh deferred;

   
   
 

   
   
RefreshTableNew_table_name;

  
  
 

Note: The SELECT statement of a materialized table is similar to a query. The table is not actually formed and the type 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;