T-SQL » Triggers » Deleting a Trigger

Syntax:
DROP TRIGGER trigger1, ...
trigger1
Is the name of the trigger(s) to be removed.

If a trigger is deleted, the table on which the trigger was created and the data in the table is not in any way affected. However, if the table is deleted, any trigger associated with the table is also deleted.

Examples

Code:
DROP TRIGGER trigAddStudentsNew;
Output:
The command(s) completed successfully.
Explanation:

Here the trigger, trigAddStudentsNew, is deleted from the database.

Language(s): MS SQL Server