I have a table like this:
CREATE TABLE BACAEN
CAEN_KEY INT PRIMARY NOT NULL,
I've already defined primary key on CAEN_KEY column. What I also need is to have unique records for CAET_KEY and BUUN_KEY together. (So, combination with same CAET_KEY / BUUN_KEY is allowed only once). The easiest way would be to generate one more composite primary key, but this is not possible because sql server doesn't allow multiple primary key constraints. What are alternatives to this?
Please note: I can not drop primary key constraint on CAEN_KEY.