title: Displaying the constraints in a table
body: <p>Hello I am trying to display the constraints in one of my tables but for some reason I get the message no rows selected.  Noted below is the table I have created.</p>
  
  <pre><code>Create table Teams (
     TeamID varCHAR2(4) constraint Teams_TeamID_PK Primary Key,
     TeamName VARCHAR2(40) 
  );
  </code></pre>
  
  <p>This is the code I am using to show my constraints.</p>
  
  <pre><code>SELECT constraint_name, 
         constraint_type,
         search_condition
    FROM USER_CONSTRAINTS
   WHERE table_name = 'Teams';
  </code></pre>
  
  <p>I am a rookie so I want to make sure I understand what is wrong.  I have tried to drop the table thinking that my constraints did not take - I did not, nor did I receive any errors when I created the table and I am referencing TeamID in another table.  So when I try to drop the table I get an error message when is what I was hoping for.</p>