| public dropTrigger ( $tgname, $table, $cascade ) | ||
| $tgname | The name of the trigger to drop | |
| $table | The table from which to drop the trigger | |
| $cascade | True to cascade drop, false to restrict | |
function dropTrigger($tgname, $table, $cascade)
{
$f_schema = $this->_schema;
$this->fieldClean($f_schema);
$this->fieldClean($tgname);
$this->fieldClean($table);
$sql = "DROP TRIGGER \"{$tgname}\" ON \"{$f_schema}\".\"{$table}\"";
if ($cascade) {
$sql .= " CASCADE";
}
return $this->execute($sql);
}