SQL Server Triggers Question:
Download Job Interview Questions and Answers PDF
Explain Syntax for viewing, dropping and disabling triggers?
Answer:
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 ]
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 ]
Download MS SQL Server Triggers Interview Questions And Answers
PDF
| Previous Question | Next Question |
| Describe triggers features and limitations? | Determine how to use the inserted and deleted pseudo tables? |