How do you modify a trigger?



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

Post New Answer

More SQL PLSQL Interview Questions

how to findout the 100th maximum salary

28 Answers   Amdocs,


Types of indexes. What is the default key created when a primary key is created in a table ?

5 Answers   TCS,


How to test for null values?

1 Answers  


When should I use nosql database?

1 Answers  


Explain the components of sql?

1 Answers  


Is sqlite free?

1 Answers  


what is autonomouse transaction?

3 Answers   Oracle,


How do I debug a stored procedure?

1 Answers  


what is top in tsql? : Transact sql

1 Answers  


how to run 'mysql' commands from a batch file? : Sql dba

1 Answers  


Any attempt to navigate programmatically to disabled form in a call_form stack is allowed?

1 Answers  


What is Collation Sensitivity ? What are the various type ?

1 Answers  


Categories