How to delete existing triggers using "drop trigger"?



How to delete existing triggers using "drop trigger"?..

Answer / 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

More SQL Server Interview Questions

Why do we use sql limitations? Which constraints can we use while making a database in sql?

1 Answers  


What are the transaction properties?

1 Answers  


What are the differences between “row_number()”, “rank()” and “dense_rank()”?

1 Answers  


When do we use the UPDATE_STATISTICS command?

4 Answers   Deutsche Telekom AG,


hi, how to link a text file and a .rpt file in my tables of sql server and to retrieve those records for further use. reply me as soon as possible.

1 Answers  


What are the types of backup and tell me the difference between full and differential backup?

4 Answers   CTS, TCS,


What are the five characteristics of good data?

1 Answers  


How do I know if localdb is running?

1 Answers  


Write a sql query to display the current date?

1 Answers  


what is statistics

1 Answers  


Which operator do you use to return all of the rows from one query except rows are returned in a second query?

1 Answers  


What is a rownum?

1 Answers  


Categories