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.