Valid in: SQL, ESQL, OpenAPI, ODBC, JDBC, .NET

The CREATE TABLE statement creates a base table. The table is owned by the user who issues the statement.

If you use the CREATE TABLE...AS SELECT syntax, the table that you create will contain a subset of the columns and values in existing tables specified by the subselect.