Data Definition Language

Create and drop tables with Teide's DDL support.

CREATE TABLE

Syntax:

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

Supported column types: INTEGER (INT), BIGINT, SMALLINT, REAL (DOUBLE, FLOAT), VARCHAR (TEXT, STRING), BOOLEAN (BOOL), DATE, TIME, TIMESTAMP. See Data Types for details.

Example:

CREATE TABLE users (id INTEGER, name VARCHAR, active BOOLEAN);
CREATE TABLE events (id INTEGER, name VARCHAR, event_date DATE, created_at TIMESTAMP);

Note: PRIMARY KEY and other column constraints are parsed but not enforced.

CREATE TABLE AS SELECT

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

CREATE TABLE from CSV

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

CREATE TABLE IF NOT EXISTS

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

CREATE OR REPLACE TABLE

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

DROP TABLE

DROP TABLE users;
DROP TABLE IF EXISTS users;