Database Tutorials MSSQL, Oracle, PostgreSQL, MySQL, MariaDB, DB2, Sybase, Teradata, Big Data, NOSQL, MongoDB, Couchbase, Cassandra, Windows, Linux 
In today’s article, we will discuss how to check the objects that are dependent on the table and how to find the dependent objects.
When we delete a table, the objects connected to that table are checked as follows, so that the objects connected to that table are not damaged.
1 | SQL> select * from DBA_DEPENDENCIES WHERE REFERENCED_NAME='CHANNEL_STATS'; |
We can find objects that depend on a table as follows.
1 2 | SQL> SELECT * FROM DBA_DEPENDENCIES D WHERE (D.REFERENCED_NAME, D.REFERENCED_TYPE) IN (SELECT NAME, TYPE FROM DBA_DEPENDENCIES D1 WHERE D1.REFERENCED_NAME IN ('ACCOUNT')); |
