SQL$HELP72.HLB  —  CREATE  TABLE  Arguments  LIKE other-table-name
    Allows a database administrator to copy the metadata for
    an existing table and create a new table with similar
    characteristics. An optional column list can be used to add extra
    columns and contraints to this table. The referenced table must
    exist in the same database as the table being created.

    Syntax options:

    LOGGING | NOLOGGING

    The LOGGING clause specifies that the CREATE TABLE statement
    should be logged in the recovery-unit journal file (.ruj) and
    after-image journal file (.aij).

    The NOLOGGING clause specifies that the CREATE TABLE statement
    should not be logged in the recovery-unit journal file (.ruj) and
    after-image journal file (.aij).

    The LOGGING clause is the default.
Close Help