Database IT Blogs

Articles, tips and tricks for databases
Tags >> Scripts
Peter Boekelaar
Why this script?
Most of the FK's defined in an Oracle DB, are not created using the on delete cascade option, since that is (most of the times) not wanted at all.
But sometimes records must be deleted while it is not allowed to do so, because there are child records (or a complete tree of child records) present.
For cases like that I use a script that searches the DB for child recs, using the SYS views.

Advertisement

Featured Links:
DreamCoder for MySQL Enterprise
Powerful MySQL GUI Client tool designed to automate and simplify database development process.
DreamCoder for Oracle DBA
Top IDE for Developers & DBAs. Browse database objects, run SQL and SQL scripts, and edit and debug PL/SQL code.
DreamCoder for PostgreSQL Enterprise
Powerful PostgreSQL admin tool. PLpg/SQL IDE for developers and DBAs.

Tags