js editor
Web development
You can remove a trigger from a database table through the interface or with the DELETE TRIGGER command.
To delete a trigger
-
In the Table tab of the Table Designer (Visual FoxPro), select the trigger expression in the Insert trigger, Update trigger, or Delete trigger box and delete it.
-or-
-
Use the DELETE TRIGGER Command.
The following example removes the update trigger for the customer table:
| В |  Copy Code |
|---|---|
DELETE TRIGGER ON customer FOR UPDATE | |
If you remove or delete a table from a database, all triggers bound to that table are deleted from the database. However, stored procedures referenced by the removed or deleted trigger are not deleted.