Sunday 1 January 2012

How to know all Table and View definitions used in a query?

This can be done using the command SHOW.
All we need to do is to put a SHOW command infront of the SQL command.

SHOW SELECT * from VIEW1;

Above statement will give all the view definitions and table DDL involved in the above query.


No comments:

Post a Comment