SQLDropTableBuilder

Topics

Initializers

• init(SQLDropTable, on: any SQLDatabase)
  Create a new SQLDropTableBuilder.

Instance Properties

• var database: any SQLDatabase
  Connection to execute query on.
• var dropTable: SQLDropTable
  SQLDropTable query being built.
• var query: any SQLExpression
  Query being built.

Instance Methods

• func behavior(SQLDropBehavior) -> Self
  The drop behavior clause specifies if objects that depend on a table should also be dropped or not when the table is dropped, for databases that support this.
• func cascade() -> Self
  Adds a CASCADE clause to the DROP TABLE statement instructing that objects that depend on this table should also be dropped.
• func ifExists() -> Self
  The optional IF EXISTS clause suppresses the error that would normally result if the table does not exist.
• func restrict() -> Self
  Adds a RESTRICT clause to the DROP TABLE statement instructing that if any objects depend on this table, the drop should be refused.
• func temporary() -> Self
  If the TEMPORARY keyword occurs between DROP and TABLE, then only temporary tables are dropped, and the drop does not cause an implicit transaction commit.