How to check Table Constraints
set linesize 190
col table_name for a40
col column_name for a40
col constraint_name for a50
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
Post a Comment