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 ?