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 |
Why do we use sql limitations? Which constraints can we use while making a database in sql?
What are the transaction properties?
What are the differences between “row_number()”, “rank()” and “dense_rank()”?
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.
What are the types of backup and tell me the difference between full and differential backup?
What are the five characteristics of good data?
How do I know if localdb is running?
Write a sql query to display the current date?
what is statistics
Which operator do you use to return all of the rows from one query except rows are returned in a second query?
What is a rownum?
Oracle (3253)
SQL Server (4518)
MS Access (429)
MySQL (1402)
Postgre (483)
Sybase (267)
DB Architecture (141)
DB Administration (291)
DB Development (113)
SQL PLSQL (3330)
MongoDB (502)
IBM Informix (50)
Neo4j (82)
InfluxDB (0)
Apache CouchDB (44)
Firebird (5)
Database Management (1411)
Databases AllOther (288)