title: Is there any way to find the foreign key, when we know the primary key it is associated with
body: <p>When I'm trying to drop a constraint of primary key on a table, I'm getting the error </p>
  
  <pre><code>ORA-02273: this unique/primary key is referenced by some foreign keys
  </code></pre>
  
  <p>How to find the foreign key that is associated with the primary key in my table.</p>
  
  <p>When I checked the constraints defined by user using <code>user_constraints</code>, its showing only the primary key of table and 3 other system constraints.</p>
  
  <pre><code>CONSTRAINT_NAME                C
  ------------------------------ -
  SYS_C0012618                   C
  SYS_C0012667                   C
  SYS_C0012881                   R
  EMP_FK                         P
  </code></pre>
  
  <p>Is there any way to find the foreign key, when we know the primary key it is associated with.</p>