displaying a table with PK first then FK?

[mp01]

Is there a way to create a table that displays tables in order of table with PK first then tables with FK?

[debasisdas]

Kindly pass more information . I think you need to look into some dictionary views for the info.

[amitpatel66]

Try this query:

SELECT acc.table_name Table_Name,
       acc.constraint_name Constraint_Name,
       acc.column_name Column_Name,
       DECODE(ac.constraint_type,'P','Primary Key','R','Foreign Key',ac.constraint_type) Constraint_Type,
       ac.r_constraint_name Referred_Constraint_Name,
       (SELECT DISTINCT table_name FROM all_constraints where constraint_name = ac.r_constraint_name) Reffered_Table_name
FROM
       all_cons_columns acc,all_constraints ac
WHERE
       acc.constraint_name = ac.constraint_name
AND    ac.constraint_type IN ('P','R')       
ORDER BY
       acc.table_name,4 DESC