Class
SQLCreateTriggerBuilder
Builds
SQLCreateTrigger queries.final class SQLCreateTriggerBuilder
Topics
Instance Properties
createTriggerSQLCreateTriggerquery being built.databaseConnection to execute query on.queryQuery being built.
Instance Methods
body(_:)Specify a body for the trigger.columns(_:)Specify the columns to which the trigger applies.condition(_:)Specify a conditional expression which determines whether the trigger is actually executed.each(_:)Identifies whether the trigger applies to each row or each statement.isConstraint()Specifies this is a constraint trigger.order(precedence:otherTriggerName:)Specify whether this trigger precedes or follows a referenced trigger.procedure(_:)Specify a procedure name for the trigger to execute.referencedTable(_:)Specify the name of another table referenced by the constraint.timing(_:)Specify the trigger’s timing.
Relationships
Conforms To
See Also
Query Builders
SQLAlterEnumBuilderBuildsSQLAlterEnumqueries.SQLAlterTableBuilderBuildsSQLAlterTablequeries.SQLConflictUpdateBuilderA builder for specifying column updates and an optional predicate to be applied to rows that caused unique key conflicts during anINSERT.SQLCreateEnumBuilderBuildsSQLCreateEnumqueries.SQLCreateIndexBuilderBuildsSQLCreateIndexqueries.SQLCreateTableBuilderBuildsSQLCreateTablequeries.SQLDeleteBuilderBuildsSQLDeletequeries.SQLDropEnumBuilderBuildsSQLDropEnumqueries.SQLDropIndexBuilderBuildsSQLDropIndexqueries.SQLDropTableBuilderBuildsSQLDropTablequeries.SQLDropTriggerBuilderBuildsSQLDropTriggerqueries.SQLInsertBuilderBuildsSQLInsertqueries.SQLPredicateGroupBuilderNestedSQLPredicateBuilderfor building expression groups.SQLRawBuilderBuilds raw SQL queries.SQLReturningResultBuilderA builder returned from the methods ofSQLReturningBuilder; this builder wraps the original builder with one which providesSQLQueryFetcherconformance. As such, thereturning(_:)methods must always be the last ones in any call chain.