CREATE TABLE AS

    The optional clause causes the error to be suppressed if the table already exists.

      Create a new table orders_column_aliased with the results of a query and the given column names:

      2. COMMENT 'Summary of orders by date'
      3. WITH (format = 'ORC')
      4. AS
      5. FROM orders

      Create the table orders_by_date if it does not already exist:

      1. CREATE TABLE empty_nation AS
      2. SELECT *
      3. WITH NO DATA

      CREATE TABLE,