title: How to remove primary key constraint from SQL Server with table name only
body: <p>I want to remove primary key constraint from a table <code>mytable</code>.</p>
  
  <p>In Mysql we can remove primary key constraint like </p>
  
  <pre><code>ALTER TABLE *mytable* DROP PRIMARY KEY
  </code></pre>
  
  <p>How to do this in SQL Server?</p>
  
  <p>Thanks for the reply in advance. :)</p>
  
  <p><strong>NB</strong>: I have a list of tables in SQL Server to remove primary key constraint. Is there any default name for primary key constraint</p>
  
  <pre><code>create table mytable 
  (
       column_a integer not null,
       column_b integer not null,
  
       primary key (column_a, column_b)
  );
  </code></pre>