I have similar task to do. With respect to this example, I would like to know the dependency of view V2 on view V1 and then on table LOT.
Is there any way to find all references using one query?
Could you please help?
Thanks in advance.
If you are looking for something that returns you the dependency in some table format then unfortuantely nothing like this exists.
But you can try SHOW QUALIFIED SELECT * FROM V2.
This will return the DDL of all the dependent views and tables...