SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

how to get all constraints which are dependent on a table

528287Aug 15 2006 — edited Aug 16 2006

Hello All,

I want to delete a table , but there are number of tables which are referencing some or the other column of this table.
So I want to know from where in the data dictionary can i get the constraints which are using columns of this particular table.

Can i generate a dynamic script to get the create scripts of all such constraints.

I need this because I will again recreate the table and need to restore different constraints in different tables which were using the columns of my newly created table before deletion.

Thanks

Locked Post

New comments cannot be posted to this locked post.

Locked on Sep 13 2006

Added on Aug 15 2006

4 comments

1,486 views