Copy Views

Database
Enthusiast

Copy Views

Hi,

I need copy some Views to other db, existe an statement or script for it ?

(some as copy db1.view1 as db.view)

BR.
1 REPLY
Enthusiast

Re: Copy Views

Documentation seems only to have CREATE TABLE in a copy syntax. Unfortunately I can only see that a copy can be done by doing the statements SHOW VIEW and then CREATE VIEW sequentially...