Syntax documentationcreate_table_statement Locate this document in the navigation structure

Syntax Syntax

  1. <create_table_statement> ::=
      CREATE TABLE <table_name>
        (<table_description_element> [,<table_description_element>,...])
        [IGNORE ROLLBACK]
        [<sample_definition>]
        [CACHE]
        [NOCACHE]
    | CREATE TABLE <table_name>
        [(<table_description_element>,...)]
        [IGNORE ROLLBACK]
        [<sample_definition>]
        AS <query_expression>
        [<duplicates_clause>]
    | CREATE TABLE <table_name> LIKE <table_name>
        [IGNORE ROLLBACK]
End of the code.