For a normal index constraint, you can find the columns it is on by querying the all_ind_columns
sysview using the index name in all_constraints
. But if the constraint is disabled, no index exists, and there doesn't seem to be anywhere else that has constraint column information. How can I get the columns of a disabled index constraint from the data dictionary (without re-enabling the constraint)?
views:
23answers:
1
+2
A:
What about ALL_CONS_COLUMMS? Seems to work find for disabled constraints of types U and P.
Jim Hudson
2010-04-20 16:10:03
Didn't spot that!
thecoop
2010-04-20 16:53:50