Getting Constraint Information in Data Dictionary
select ac.owner ,ac.CONSTRAINT_NAME
,ac.CONSTRAINT_TYPE
,ac.TABLE_NAME
,acc.column_name
,acc.position
from all_constraints ac
,all_cons_columns acc
where ac.owner IN ('CPSADMIN','ISYNC')
and constraint_type <> 'C'
and ac.constraint_name = acc.constraint_name
and ac.table_name = acc.table_name
order by constraint_type ,constraint_name , position;
I am using this query to get constraint information but cannot find a way to display the PK source for my FKs.
What am I missing?
thanks
Alan
,ac.CONSTRAINT_TYPE
,ac.TABLE_NAME
,acc.column_name
,acc.position
from all_constraints ac
,all_cons_columns acc
where ac.owner IN ('CPSADMIN','ISYNC')
and constraint_type <> 'C'
and ac.constraint_name = acc.constraint_name
and ac.table_name = acc.table_name
order by constraint_type ,constraint_name , position;
I am using this query to get constraint information but cannot find a way to display the PK source for my FKs.
What am I missing?
thanks
Alan
0