Posted by rogergorden@gmail.com on 11/28/06 17:09

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.

[Back to original message]