Learning bLog

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 hel...