Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.misc -> NEED SCRIPT: list all constraints
Does anyone out there know of a good set of scripts to display information about a set of tables, in particular the constraints? My database was constructed with foreign key and other constraints which are not documented (at least, not in a way which is accessible to me), and trying to create test data is a problem if you don't satisfy the referential integrity. Oh, and for some reason the view CONSTRAINT_DEFS, alluded to in the Oracle dox, is missing. Is that one of those that has to be created by the DBA? Received on Thu Oct 02 1997 - 00:00:00 CDT
![]() |
![]() |