Using SELECT INTO to Create a New Permanent Table

Using Extended Parallel Server, you can use the SELECT INTO statement to create a new permanent table based on the result set of a SELECT statement.

When using SELECT INTO to create a new table, you must specify its type. You can optionally specify storage and lock mode options for the new table.

The column names of the new permanent table are the names specified in the select list. If an "*" appears in the select list, it is expanded to all the columns of the corresponding tables or views in the SELECT statement.

All expressions other than simple column expressions must have a display label. This is used as the name of the column in the new table. If a column expression has no display label, the table uses the column name. If there are duplicate labels or column names in the select list, an error will be returned.