How do I see what a MySQL view is made of?

Question

I'm sure this is easy to do, but I can't find how to do it! How do I see what a view in MySQL is made of? Basically, how do I see what statements were used in the original CREATE VIEW?

Answer 1

I would suggest something like this:

SHOW CREATE VIEW

Answer 2

See the documents on SHOW CREATE VIEW

SHOW CREATE VIEW viewname;

And actually, I usually use \G to suppress tabular output for easier reading:

SHOW CREATE VIEW viewname\G