OSEC

Neohapsis is currently accepting applications for employment. For more information, please visit our website www.neohapsis.com or email hr@neohapsis.com
 
Re: Finding Tables created by views

From: Dan Nelson (dnelsonallantgroup.com)
Date: Thu Jul 01 2004 - 14:50:09 CDT


In the last episode (Jul 01), Martin Gainty said:
> I have a table that is chock full of errors..(PLAN shows Table Access
> full) so I know that it was created wrong Is there an easy way to
> setup a query to locate all views that use this table?

Mysql doesn't support views yet. It's planned for 5.0, I think.

--
        Dan Nelson
        dnelsonallantgroup.com

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql