How to rename a view in MySQL?

Question

I have created a view vw_extr.

Now I want to rename it vw_my.

How can a view be renamed in MySQL?

question from:https://stackoverflow.com/questions/5475473/how-to-rename-a-view-in-mysql

Answer 1

You can use RENAME TABLE for that:

RENAME TABLE vw_extr to vw_my