How do you modify a trigger?
Answer / Sudha
To modify an existing trigger in SQL, you would typically drop the old trigger and then create a new one with the updated logic. Here's a basic example using MySQL: DROP TRIGGER trigger_name; CREATE TRIGGER trigger_name AFTER EVENT FOR EACH ROW BEGIN ... END;
| Is This Answer Correct ? | 0 Yes | 0 No |
how to findout the 100th maximum salary
Types of indexes. What is the default key created when a primary key is created in a table ?
How to test for null values?
When should I use nosql database?
Explain the components of sql?
Is sqlite free?
what is autonomouse transaction?
How do I debug a stored procedure?
what is top in tsql? : Transact sql
how to run 'mysql' commands from a batch file? : Sql dba
Any attempt to navigate programmatically to disabled form in a call_form stack is allowed?
What is Collation Sensitivity ? What are the various type ?
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)