How to delete existing triggers using "drop trigger"?
- 1 Answers
- 1144 Views
- I also Faced
- E-Mail Answers
Answer Posted / Amarjeet Kumar Paswan
To delete an existing trigger, use the DROP TRIGGER statement followed by the name of the trigger. Here's an example:
```sql
DROP TRIGGER [SchemaName].[TriggerName]
```
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
How to rebuild the master database?
Is it possible to have clustered index on separate drive from original table location?
What kind of problems occurs if we do not implement proper locking strategy?
How to remove duplicate rows from table except one?
You have a stored procedure, which execute a lengthy batch job. This stored procedure is called from a trigger you do not want to slow the data entry process you do not want trigger to wait for this batch job to finish before it completes itself what you can do to speed up the process?
do you know how to configure db2 side of the application? : Sql server database administration
What are the different SQL Server Versions you have worked on?
How do I find the sql server version?
How can we solve concurrency problems?
What are the different subsets of sql?
How to convert character strings into numeric values?
Equi join and non equi join is possible with sql server?
Does view occupy space?
Disadvantages of the indexes?
How can I check that whether automatic statistic update is enabled or not?
