Constraint

Less than 1 minute

Methods

Retrieves a list of constraints for a given table or all tables in the schema.

public listConstraints(NULL $table, NULL $type, boolean $invertType, false $): void

Parameter	Type	Description
`$table`	`NULL`	The name of the table. If null, constraints for all tables in the schema will be retrieved.
`$type`	`NULL`	The type of constraints to retrieve. If null, all types of constraints will be retrieved.
`$invertType`	`boolean`	Whether to invert the constraint type filter. If true, constraints of types other than the specified type will be retrieved.
`$`	`false`

Adds a constraint to a table in the database.

public addConstraint(string $constraintName, array $info): bool

Parameter	Type	Description
`$constraintName`	`string`	the name of the constraint to add
`$info`	`array`	An associative array containing information about the constraint. - 'table' (string): The name of the table to which the constraint will be added. - 'type' (string): The type of the constraint (e.g., 'FOREIGN KEY'). If not provided and 'references' is present, defaults to 'FOREIGN KEY'. - 'column' (string

public dropConstraint(string $constraintName, string $tableName, bool $ifExists, bool $cascade): bool