Explain Syntax for viewing, dropping and disabling triggers?
Submitted by: AdministratorView 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
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
Read Online SQL Server Triggers Job Interview Questions And Answers
Top SQL Server Triggers Questions
☺ | Explain trigger classes i.e. instead of and after trigger? |
☺ | Explain Syntax for viewing, dropping and disabling triggers? |
☺ | What are the instances when triggers are appropriate? |
☺ | Explain triggers? |
☺ | How to invoke a trigger on demand? |
Top New MS SQL Server Categories
☺ | SQL Server Database Administrator Interview Questions. |
☺ | SQL Server Service Broker Interview Questions. |
☺ | SQL Server Locks Interview Questions. |
☺ | SQL Server Constraints Interview Questions. |
☺ | MS SQL Data Mining Interview Questions. |