To determine the dependencies for a table, you may use a query similar to the one on the right. It selects all the views or MQTs dependent on a given table, in this case 'DEMOADM.DEPT'. If you use SQL to answer questions like this on a regular basis, you may also:

Without some kind of tool you have to remember where the data is stored, what columns you want to look at, and the table and schema you need to look up.

Goal:

Explore the SQL used to retrieve table dependencies.

Steps to complete: