How to: Remove or Delete Triggers

JavaScript Editor js editor     Web development 



Main Page

You can remove a trigger from a database table through the interface or with the DELETE TRIGGER command.

To delete a trigger

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.

See Also



JavaScript Editor js editor     Web development