I want to see how is it constructed[by what query], a Mysql View

lse123

02-19-2009, 10:56 AM

In PHPMYADMIN when I create a Mysql View , and later[6mo] I want to see how is it constructed [by what query], may do this by anyway ?

guelphdad

02-19-2009, 01:52 PM

SHOW CREATE VIEW nameoftheview