Reputation: 23
After creation of a view, is there any command to get the query that created the view in mysql.
I can save the query somewhere but mysql command can be useful anytime.
Upvotes: 2
Views: 3076
Reputation: 26784
Just use show create
SHOW CREATE VIEW view_name
Upvotes: 10