Sorry, this is probably something very obvious.

I created a View in MySQL some time ago, and now need to see the SELECT
statement that defines it. Is it possible to extract and see this query
in any way?

--
CB

Christoph Burschka wrote:
> Sorry, this is probably something very obvious.
>
> I created a View in MySQL some time ago, and now need to see the SELECT
> statement that defines it. Is it possible to extract and see this query
> in any way?
>
> --
> CB

In the INFORMATION_SCHEMA database, query the table called views. The
TABLE_NAME is the view_name and the VIEW_DEFINITION is the SQL that
defines the view.