SQLCreateTableBuilder

Topics

Initializers

• init(_:on:)
  Create a new SQLCreateTableBuilder.

Instance Properties

• columns
  The set of column definitions.
• createTable
  SQLCreateTable query being built.
• database
  Connection to execute query on.
• query
  Query being built.

Instance Methods

• check(_:named:)
  Add a CHECK constraint to the table.
• column(_:)
  Add a new column definition.
• column(_:type:_:)
  Add a new column by name, type, and constraints.
• column(definitions:)
  Add multiple column definitions.
• foreignKey(_:references:_:onDelete:onUpdate:named:)
  Add a FOREIGN KEY constraint to the table.
• ifNotExists()
  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.
• primaryKey(_:named:)
  Add a PRIMARY KEY constraint to the table.
• select(_:)
  Specify a SELECT query to be used to populate the new table.
• temporary()
  Mark the new table as temporary.
• unique(_:named:)
  Add a UNIQUE constraint to the table.