title: An object with the name already exist in the database just when I use constraint
body: <p>When I use this script:</p>
  
  <pre><code>IF OBJECT_ID('dbo.TableX', 'U') IS NOT NULL 
      DROP TABLE dbo.TableX
  
  CREATE TABLE TableX
  (
      ...
      ...
      ...
  
      CONSTRAINT TableX PRIMARY KEY (column1, column2, column3)
  )
  </code></pre>
  
  <p>I get an error </p>
  
  <blockquote>
    <p>An object with the name 'TableX' already exist in the database</p>
  </blockquote>
  
  <p>but that is only when I use the <code>CONSTRAINT</code> line.</p>
  
  <p>Why do I get an error only when I use <code>CONSTRAINT</code> and how can I solve it?</p>