Partager via


How to: Remove or Delete Triggers

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:

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

Tasks

How to: Edit Table Structure

Concepts

Trigger Usage

Other Resources

Working with Tables (Visual FoxPro)