Re: View tables with no Foreign Keys?

RJ wrote:
> Hi All,
>
> Is there a statement (any method) of getting a list of tables with no
> FK references?
>
> Thanks..

SELECT table_name
FROM user_tables
WHERE table_name NOT IN (

   SELECT table_name
   FROM user_constraints
   WHERE constraint_type = 'R');

-- 
Daniel Morgan
University of Washington
Puget Sound Oracle Users Group