|
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.
Navigation:
[Reply to this message]
|