View to show how a constraint was created
There are two ways to create a unique constraint with index:- create a UK constraint by "alter table add constraint". The DB will create a constraint and an index in one step;
- create a unique index by "create unique index" and then create a constraint by "alter table add constraint using index".
Is there a way to identify how a constraint was created looking in the Oracle dictionary?
checking i found
that we can n query dba_objects or user_object for field created for both index and constraint and compare
Is there another way ?
Please advice
Thanks in advance
- create a unique index by "create unique index" and then create a constraint by "alter table add constraint using index".
Is there a way to identify how a constraint was created looking in the Oracle dictionary?
checking i found
that we can n query dba_objects or user_object for field created for both index and constraint and compare
Is there another way ?
Please advice
Thanks in advance
0