How to check Table Constraints

How to check Table Constraints


set linesize 190
col table_name for a40
col column_name for a40
col constraint_name for a50

SELECT 
    a.table_name, 
    a.column_name, 
    c.constraint_type,
c.constraint_name
FROM 
    all_tab_columns a
JOIN 
    all_cons_columns b ON a.table_name = b.table_name AND a.column_name = b.column_name
JOIN 
    all_constraints c ON b.constraint_name = c.constraint_name
WHERE 
    a.table_name IN ('&Table_Name') and a.owner='&Schema' ORDER BY a.table_name, a.column_name;


Comments