SQL Server Triggers Interview Question:

Explain Syntax for viewing, dropping and disabling triggers?

Submitted by: Administrator

View trigger:

A trigger can be viewed by using sp_helptrigger syntax. This returns all the triggers defined in a table.

Sp_helptrigger table_name

Drop a trigger
Syntax: DROP TRIGGER Trigger_name

Disable a trigger:-
Syntax: DISABLE TRIGGER [schema name] trigger name
ON [object, database or ALL server ]
Submitted by: Administrator