DELETE TRIGGER Command

Example   See Also

Removes a Delete, Insert, or Update trigger for a table from the current database.

Syntax

DELETE TRIGGER ON TableName FOR DELETE | INSERT | UPDATE

Arguments

TableName

Specifies the name of table for which the trigger is deleted.

FOR DELETE | INSERT | UPDATE

Specifies the trigger to delete. Include FOR DELETE to remove the Delete trigger, FOR INSERT to remove the Insert trigger, and FOR UPDATE to remove the Update trigger.

Remarks

Use CREATE TRIGGER to create a Delete, Insert, or Update trigger for a table.