SQL SERVER – Drop Contraint

/* For SQL Server/Oracle/MS ACCESS */
ALTER TABLE Table1
DROP CONSTRAINT PK_Table1_Col1
GO

/* For MySql */
ALTER TABLE Table1
DROP PRIMARY KEY
GO 

(http://blog.sqlauthority.com/2009/05/12/sql-server-how-to-drop-primary-key-contraint)