How to drop Primary Key of a Table using MSSQL

Apr 21, 2015 drop, microsof, microsoft, microsoft sequel server, microsoft sql, Microsoft SQL Server, Microsoft SQL Server 2005, Microsoft SQL Server 2008, Microsoft SQL Server 2008R2, Microsoft SQL Server 2012, mssql, primary key, SQL, T-SQL

To drop Primary Key of a Table using MSSQL you can use the snippet below.

http://youtu.be/0kfyw8M83bA

Sample MSSQL

ALTER TABLE tblTest
DROP CONSTRAINT PK_tblTest
GO

May 22, 2015 Administrator

Apr 15, 2015 Administrator

Mar 24, 2015 Administrator