Trigger

Less than 1 minute

Methods

List defined triggers.

public listTriggers(?string $tableName): void

Parameter	Type	Description
`$tableName`	`string`

public triggerExists(string $triggerName, string $tableName): bool

Parameter	Type	Description
`$triggerName`	`string`
`$tableName`	`string`

Describe a database trigger.

public describeTrigger(string $triggerName, ?string $schemaName, false $): void

This will return an array as there can be multiple triggers with the same name but with different attributes

Parameter	Type	Description
`$triggerName`	`string`
`$schemaName`	`string`	Optional: schemaName name. If not supplied the current schemaName is used.
`$`	`false`

Summary of createTrigger.

public createTrigger(string $triggerName, string $tableName, mixed $spec = []): bool

Parameter	Type	Description
`$triggerName`	`string`
`$tableName`	`string`	The table on which the trigger is being created
`$spec`	`mixed`	The spec of the trigger. Basically this is the array returned from describeTriggers()

Drop a trigger from a table.

public dropTrigger(string $triggerName, string $tableName, bool $cascade = false, bool $ifExists = false): bool

Parameter	Type	Description
`$triggerName`	`string`
`$tableName`	`string`	The name of the table to remove the trigger from
`$cascade`	`bool`	Whether to drop CASCADE
`$ifExists`	`bool`