Show TOC

create_table_statementLocate this document in the navigation structure

			
<create_table_statement>::=
  CREATE TABLE <table_name>
    (<table_description_element> [,<table_description_element>,...])
    [IGNORE ROLLBACK]
    [<sample_definition>]
    [CACHE] [NOCACHE]
    [IN DATASOURCE <data_source_name>]
| CREATE TABLE <table_name>
    [(<table_description_element>,...)]
    [IGNORE ROLLBACK]
    [<sample_definition>]
    AS <query_expression>
    [<duplicates_clause>]
    [IN DATASOURCE <data_source_name>]
| CREATE TABLE <table_name> LIKE <table_name>
    [IGNORE ROLLBACK]
    [IN DATASOURCE <data_source_name>]