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 at USD 69.95
Powerful and easy MySQL IDE tool for Developers & DBAs.
DreamCoder for Oracle DBA at USD 99.95
The top IDE for Developers & DBAs for Oracle Databases.
DreamCoder for PostgreSQL Enterprise at USD 69.95
Powerful IDE for PostgreSQL Databases.

Tags