Structure
SQLCreateTable
An expression representing a
CREATE TABLE query. Used to create new tables.struct SQLCreateTableOverview
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
Topics
Initializers
init(name: any SQLExpression)Create a new table creation query.
Instance Properties
var asQuery: (any SQLExpression)?If notnil, aSELECTsubquery which is used to populate the new table.var columns: [any SQLExpression]A list of one or more column definitions to include in the new table.var ifNotExists: BoolIftrue, requests idempotent behavior for table creation.var table: any SQLExpressionThe name of the new table.var tableConstraints: [any SQLExpression]A list of zero or more table constraints to specify on the new table.var temporary: BoolIftrue, the table is marked temporary, limiting its lifetime to that of the current database session.
Instance Methods
func serialize(to: inout SQLSerializer)Invoked when a request is made to serialize the expression to raw SQL.
Relationships
Conforms To
SQLExpressionSwift.SendableSwift.SendableMetatype
See Also
Query Expressions
struct SQLAlterEnumAn expression representing anALTER TYPEquery. Used to add new cases to enumeration types.struct SQLAlterTableAn expression representing anALTER TABLEquery. Used to modify the structure of existing tables.struct SQLCreateEnumAn expression representing aCREATE TYPEquery. Used to create enumeration types.struct SQLCreateIndexAn expression representing aCREATE INDEXquery. Used to add indexes over columns to an existing table.struct SQLCreateTriggerAn expression representing aCREATE TRIGGERquery. Used to create new triggers for actions on a table.struct SQLDeleteAn expression representing aCREATE TRIGGERquery. Used to remove rows from a table.struct SQLDropEnumAn expression representing aDROP TYPEquery. Used to delete enumeration types.struct SQLDropIndexAn expression representing aDROP INDEXquery. Used to delete indexes from tables.struct SQLDropTableAn expression representing aDROP TABLEquery. Used to delete entire tables.struct SQLDropTriggerAn expression representing aDROP TRIGGERquery. Used to delete triggers.struct SQLInsertAn expression representing anINSERTquery. Used to add new rows to a table.struct SQLSelectAn expression representing aSELECTquery. Used to retrieve rows and expression results from a database.struct SQLUnionAn expression representing two or moreSELECTqueries joined byUNIONclauses. Used to merge the results of multiple queries into a single result set.struct SQLUpdateAn expression representing anUPDATEquery. Used to modify existing rows in a single table.