SQLCreateTableBuilder

Topics

Initializers

• init(SQLCreateTable, on: any SQLDatabase)
  Create a new SQLCreateTableBuilder.

Instance Properties

• var columns: [any SQLExpression]
  The set of column definitions.
• var createTable: SQLCreateTable
  SQLCreateTable query being built.
• var database: any SQLDatabase
  Connection to execute query on.
• var query: any SQLExpression
  Query being built.

Instance Methods

• func check(_:named:)
  Add a CHECK constraint to the table.
• func column(any SQLExpression) -> Self
  Add a new column definition.
• func column(_:type:_:)
  Add a new column by name, type, and constraints.
• func column(definitions: [SQLColumnDefinition]) -> SQLCreateTableBuilder
  Add multiple column definitions.
• func foreignKey(_:references:_:onDelete:onUpdate:named:)
  Add a FOREIGN KEY constraint to the table.
• func ifNotExists() -> Self
  It is usually an error to attempt to create a new table in a database that already contains a table, index or view of the same name. However, if the “IF NOT EXISTS” clause is specified as part of the CREATE TABLE statement and a table or view of the same name already exists, the CREATE TABLE command simply has no effect (and no error message is returned). An error is still returned if the table cannot be created because of an existing index, even if the “IF NOT EXISTS” clause is specified.
• func primaryKey(_:named:)
  Add a PRIMARY KEY constraint to the table.
• func select((SQLSubqueryBuilder) throws -> SQLSubqueryBuilder) rethrows -> Self
  Specify a SELECT query to be used to populate the new table.
• func temporary() -> Self
  Mark the new table as temporary.
• func unique(_:named:)
  Add a UNIQUE constraint to the table.