通过

Removing or Deleting Triggers

  • 项目

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, 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:

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

Creating Triggers | Modifying Triggers | Working with Tables | Trigger Usage | Modifying the Table Structure | Adding Fields