SQL REFERENCE

Data Definition Language

Create and drop tables with Teide's DDL support.

CREATE TABLE

Syntax:

CREATE TABLE table_name (
  column_name TYPE,
  ...
);

Example:

CREATE TABLE users (id INTEGER, name VARCHAR, active BOOLEAN);

CREATE TABLE summary AS
SELECT grp, SUM(val) AS total
FROM source_table
GROUP BY grp;

CREATE TABLE trades AS SELECT * FROM read_csv('trades.csv');

CREATE TABLE IF NOT EXISTS users (id INTEGER, name VARCHAR);

CREATE OR REPLACE TABLE t AS SELECT x * 10 AS x FROM t;

DROP TABLE users;
DROP TABLE IF EXISTS users;