How to disable a Primary key on a table ?

Question

Hi Please answer the above question.

Pravin More · Answer

yes Gunti it is also possible........ ALTER INDEX index_name ON dbo.Tablename DISABLE and for reenable.......... ALTER INDEX ALL ON dbo.Tablename rebuild Thanks Pravin.

Dhaval Patel · Answer

Dear Gunti Are you want to use for oracle then use this ALTER TABLE TableName ADD PRIMARY KEY ( TableField ) DISABLE; but if you want to use for sql server then Pravin More answer is right. Thanks & regards Dhaval Patel If this post help then please Mark As Accepted Answer

Gunti Dilip · Answer

Without Dropping a Primary key is there any way to disable it.

Pravin More · Answer

Hi Gunti you can use below query......you can easily get to know the name of primary key by table field property ALTER TABLE YourTableName DROP CONSTRAINT PK_Name Note: replace name of Primary ket you want to remove instead PK_Name . Thanks Pravin.