Skip to content

Structure

SQLCreateTable

An expression representing a CREATE TABLE query. Used to create new tables.
struct SQLCreateTable

Overview

CREATE TEMPORARY TABLE IF NOT EXISTS "table" (
    "id" INT NOT NULL GENERATED BY DEFAULT AS IDENTITY,
    "column1" TEXT NOT NULL,
    UNIQUE ("column1")
) AS SELECT
    DEFAULT AS "id",
    "column1"
FROM
    "other_table";

Temporary tables and the IF NOT EXISTS modifier are ignored when not supported by the dialect

See SQLCreateTableBuilder.

Topics

Initializers

Instance Properties

  • asQuery
    If not nil, a SELECT subquery which is used to populate the new table.
  • columns
    A list of one or more column definitions to include in the new table.
  • ifNotExists
    If true, requests idempotent behavior for table creation.
  • table
    The name of the new table.
  • tableConstraints
    A list of zero or more table constraints to specify on the new table.
  • temporary
    If true, the table is marked temporary, limiting its lifetime to that of the current database session.

Instance Methods

  • serialize(to:)
    Invoked when a request is made to serialize the expression to raw SQL.

Relationships

Conforms To

See Also

Query Expressions

  • SQLAlterEnum
    An expression representing an ALTER TYPE query. Used to add new cases to enumeration types.
  • SQLAlterTable
    An expression representing an ALTER TABLE query. Used to modify the structure of existing tables.
  • SQLCreateEnum
    An expression representing a CREATE TYPE query. Used to create enumeration types.
  • SQLCreateIndex
    An expression representing a CREATE INDEX query. Used to add indexes over columns to an existing table.
  • SQLCreateTrigger
    An expression representing a CREATE TRIGGER query. Used to create new triggers for actions on a table.
  • SQLDelete
    An expression representing a CREATE TRIGGER query. Used to remove rows from a table.
  • SQLDropEnum
    An expression representing a DROP TYPE query. Used to delete enumeration types.
  • SQLDropIndex
    An expression representing a DROP INDEX query. Used to delete indexes from tables.
  • SQLDropTable
    An expression representing a DROP TABLE query. Used to delete entire tables.
  • SQLDropTrigger
    An expression representing a DROP TRIGGER query. Used to delete triggers.
  • SQLInsert
    An expression representing an INSERT query. Used to add new rows to a table.
  • SQLSelect
    An expression representing a SELECT query. Used to retrieve rows and expression results from a database.
  • SQLUnion
    An expression representing two or more SELECT queries joined by UNION clauses. Used to merge the results of multiple queries into a single result set.
  • SQLUpdate
    An expression representing an UPDATE query. Used to modify existing rows in a single table.