Remove PK, FK constraint from SQL Server table

I'm weak in databases and consult Google every time if I'm new to the concept OR baffled somewhere. Some days back I got simple requirement which is nothing but to drop the PK constraint from a table, Initially I thought it was easy to do but got stuck and finally came up with solution.This is what straight forward thing I did

-- Problem: Remove the PK constraint from the table 'test',
-- Solution:
-- 1. Get the table constraint using following query
SELECT CONSTRAINT_NAME FROM INFORMATION_SCHEMA.TABLE_CONSTRAINTS
WHERE TABLE_NAME = 'test';
-- 2. It returns a column CONSTRAINT_NAME with the list of constraint, like, PK, FK, etc

--|CONSTRAINT_NAME|
-------------------
--|PK_test |

-- 3. The PK constraint name generally starts with "PK_table_name[_xxx]"
-- 4. Remove it using following query
ALTER TABLE test
DROP CONSTRAINT PK_test;
-- 5. You just drop the PK constraint from table 'test', hurray !!! :)


Hope this helps someone who is struggling like me :)

Comments

Popular Posts