title: What is the difference between Primary Key only and Primary Key constraint?
body: <p>I am very new to SQL and if my question is silly please forgive my ignorance.</p>
  
  <p>What is the difference between Primary Key only and Primary Key constraint?</p>
  
  <p>Difference between
  <strong>This</strong></p>
  
  <pre><code>CREATE TABLE CUSTOMERS(
     ID   INT              NOT NULL,
     PRIMARY KEY (ID, NAME)
  </code></pre>
  
  <p>and <strong>This</strong></p>
  
  <pre><code>CREATE TABLE CUSTOMERS(
     ID   INT              NOT NULL,
    CONSTRAINT [Pk_ID_Name] PRIMARY KEY (ID, NAME)
  </code></pre>
  
  <p>Thank you,
  Dash</p>