CREATE TABLE AS

    如果使用可选的 子句,则在表已存在时禁止显示错误。

      使用查询结果和给定的列名创建表 orders_column_aliased

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

      如果表 orders_by_date 尚不存在,则创建该表:

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

      CREATE TABLE