Hi,

I have a table with 4 columns that are a primary key and now the business requirements have changed and one of the columns should be dropped, and the primary key will br of ther remaining 3 columns.

I am pretty sure that I cannot drop a column that is part of a primary key, so the question is what would be the most effecient way to perfrom it ?

Can I disable/enable the primary key or do I need to drop and create it ?

You need to first drop the key, then the column and then recreate the primary key based on new set of columns.