Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

If there are any triggers associated with a table which is renamed to new name as trigger code still points to old table name

As mysql document it says statement fails with the error Trigger in wrong schema and it behaves the same.

Is there any command to rename the new_table_names even in triggers.

share|improve this question
If there is it will vary on RDBMS product. Which product are you using? – WindRaven Mar 19 '14 at 16:25
Its an MySQL – Anil Alpati Mar 20 '14 at 9:29

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Browse other questions tagged or ask your own question.