I have wriiten this Procedure which Drop all primary keys
in whole database Dynamically. Create This Procedure in any User database . Execute it . It Will drop all Primary Keys
Harnessing SQL Server Metadata- Disabling and Rebuilding Indexes
When doing bulk data changes it may be beneficial to disable indexes prior to starting the operation. Fortunately, SQL's rich metadata makes this very easy to automate in a robust fashion.
2018-05-18 (first published: 2015-10-19)