GNU/Linux |
RedHat 6.2(Zoot) |
|
![]() |
create_table_as(l) |
![]() |
CREATE TABLE AS − Creates a new table
CREATE TABLE
table [ (column [, ...] ) ]
AS select_clause
INPUTS
table |
The name of a new table to be created. | ||
column |
The name of a column. Multiple column names can be specified using a comma-delimited list of column names. |
select_clause
A valid query statement. Refer to SELECT for a description of the allowed syntax.
OUTPUTS
Refer to CREATE TABLE and SELECT for a summary
of possible output messages.
CREATE TABLE AS enables a table to be created from the contents of an existing table. It is functionality equivalent to select_into(l), but with perhaps a more direct syntax.
![]() |
create_table_as(l) | ![]() |