CONSTRAINT: individua le FOREIGN KEY associate ad una tabella
Per individuare le fk associate ad una tabella:
select c.owner , c.table_name, c.constraint_name
from ALL_CONSTRAINTS c
where r_constraint_name
in (
select constraint_name
from all_constraints
where owner ='<schema>'
--and constraint_type <> 'R'
and table_name='<nometabella>'
)
and c.constraint_type ='R';
select c.owner , c.table_name, c.constraint_name
from ALL_CONSTRAINTS c
where r_constraint_name
in (
select constraint_name
from all_constraints
where owner ='<schema>'
--and constraint_type <> 'R'
and table_name='<nometabella>'
)
and c.constraint_type ='R';