Presto 101t Documentation

8.2. CREATE TABLE

8.2. CREATE TABLE

Synopsis

CREATE TABLE table_name (
  column_name data_type [, ...]
)

Description

Create a new, empty table with the specified columns. Use CREATE TABLE AS to create a table with data.

Examples

Create a new table orders:

CREATE TABLE orders (
  orderkey bigint,
  orderstatus varchar,
  totalprice double,
  orderdate date
)