Pandu Ranga Rao
Pandu Ranga Rao

Reputation: 23

Get the view definition in mysql

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

Answers (1)

Mihai
Mihai

Reputation: 26784

Just use show create

SHOW CREATE VIEW view_name

Upvotes: 10

Related Questions