8. OpenSQL Statements : CREATE TABLE : Description
 
Share this page                  
Description
The CREATE TABLE statement creates a new base table owned by the user who issues the statement. If you use the CREATE TABLE...AS syntax, then the table that you create is a subset of the columns and values in existing tables defined by the subselect.
To ensure application portability, follow every CREATE TABLE statement with a COMMIT statement.