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
