Answer Posted / chandrakant agrawal
To recompile Trigger:
ALTER TRIGGER <trigger_name> COMPILE;
The trigger can be enabled and disabled manually by using:
Alter Table <table_name> disable(enable) all trigger;
| Is This Answer Correct ? | 5 Yes | 1 No |
Post New Answer View All Answers
what are date and time data types in mysql? : Sql dba
How to fetch alternate records from a table?
Differences between Oracle 9i and 10g (Probably in terms of SQL and PL/SQL)?
what are all the common sql function? : Sql dba
Are subqueries better than joins?
How do I view stored procedures?
What are pl/sql packages?
How do I view a table in sql?
how to decrement dates by 1 in mysql? : Sql dba
Explain what is a subquery ?
How do I run a sql query in pgadmin 4?
Is left join same as join?
What is spool?
What view means?
What is sql indexing?