SQLDropIndexBuilder

Topics

Initializers

• init(SQLDropIndex, on: any SQLDatabase)
  Create a new SQLDropIndexBuilder.

Instance Properties

• var database: any SQLDatabase
  Connection to execute query on.
• var dropIndex: SQLDropIndex
  SQLDropIndex 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 index should also be dropped or not when the index is dropped, for databases that support this.
• func cascade() -> Self
  Adds a CASCADE clause to the DROP INDEX statement instructing that objects that depend on this index should also be dropped.
• func ifExists() -> Self
  The optional IF EXISTS clause suppresses the error that would normally result if the index does not exist.
• func on(_:)
  Convenience method for specifying an owning object using a String. See on(_:) for details.
• func restrict() -> Self
  Adds a RESTRICT clause to the DROP INDEX statement instructing that if any objects depend on this index, the drop should be refused.