SQL- Tricks

Schlüssel- Fehler

https://stackoverflow.com/questions/11879217/display-names-of-all-constraints-for-a-table-in-oracle-sql

Error Msg = ORA-02291: Integritäts-Constraint () verletzt - übergeordneter Schlüssel nicht gefunden:

SELECT *
  FROM user_cons_columns
 WHERE TABLE_NAME = '<your table name>';
SELECT *
  FROM user_constraints
 WHERE TABLE_NAME = '<your table name>'
   AND constraint_name = '<your constraint name>';

oder auch https://stackoverflow.com/questions/11868758/find-parent-key-in-a-constraint

For the parent table:

SELECT * FROM all_constraints 
         WHERE constraint_name IN (
               SELECT R_CONSTRAINT_NAME 
                 FROM all_constraints 
                WHERE constraint_name = 'ADS_JOB_FAMILIES_F03'); 

For the parent column:

SELECT * 
  FROM all_cons_columns 
 WHERE constraint_name IN (
       SELECT constraint_name 
         FROM all_constraints 
        WHERE constraint_name IN (
              SELECT R_CONSTRAINT_NAME 
                FROM all_constraints 
               WHERE constraint_name = 'ADS_JOB_FAMILIES_F03'));