Pegasus InfoCorp: Web site design and web software development company

CREATE_TABLE_AS (l)

Creates a new table

SYNOPSIS

    CREATE TABLE table [ (column [, ...] ) ]
         AS select_clause
    

    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.

    Refer to CREATE TABLE and SELECT for a summary of possible output messages.

DESCRIPTION

    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.