| public dropConstraint ( $constraint, $relation, $type, $cascade ) | ||
| $constraint | The constraint to drop | |
| $relation | The relation from which to drop | |
| $type | The type of constraint (c, f, u or p) | |
| $cascade | True to cascade drop, false to restrict | |
function dropConstraint($constraint, $relation, $type, $cascade)
{
$f_schema = $this->_schema;
$this->fieldClean($f_schema);
$this->fieldClean($constraint);
$this->fieldClean($relation);
$sql = "ALTER TABLE \"{$f_schema}\".\"{$relation}\" DROP CONSTRAINT \"{$constraint}\"";
if ($cascade) {
$sql .= " CASCADE";
}
return $this->execute($sql);
}