Explain syntax for viewing, dropping and disabling triggers?
- 1 Answers
- 1027 Views
- I also Faced
- E-Mail Answers
Answer Posted / Shashank Saxena
To view triggers: `SELECT * FROM sys.triggers`nTo drop a trigger: `DROP TRIGGER [schema_name].[trigger_name]`nTo disable a trigger: `DISABLE TRIGGER [schema_name].[trigger_name] ON [table_name]`nTo enable a trigger: `ENABLE TRIGGER [schema_name].[trigger_name] ON [table_name]`
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
What is an indexed view?
List out the different types of locks available in sql server?
How to connect php with different port numbers?
what is spatial nonclustered index
What is the primary use of the model database?
What are the different SQL Server Versions you have worked on?
What are the risks of storing a hibernate-managed object in a cache? How do you overcome the problems?
Equi join and non equi join is possible with sql server?
Why and when do stored procedure recompile?
What are the source of constraints?
What is self contained sub query?
What is the difference between upgrade and migration in sql server?
How do I create a trace in sql server?
How to convert numeric expression data types using the cast() function?
Why we use the openxml clause?
