title: Stored procedure and where type in P, U, PC
body: <p>I'm beginner in SQL. I can't find what is this line: </p>
  
  <pre><code>type in (N'P', N'PC')
  </code></pre>
  
  <p>What is in where clause: P, PC, U?</p>
  
  <p>EDIT:</p>
  
  <p>The full query is:</p>
  
  <pre><code>IF EXISTS (SELECT * 
               FROM sys.objects 
              WHERE object_id = OBJECT_ID(N'[dbo].SP_AUTHENTIFICATION]') 
                AND type in (N'P', N'PC'))
  </code></pre>