how to make 2 columns in DB as primary key

Priyanka over 7 years ago

how to make 2 columns in DB as primary key .
There is a table with columns , fundid, business effective month, profit, loss and other fields.
I have made fundid as primary key. But I should make fundid and business effective month , both together as primary key . How to do that in CDT ?

Discussion posts and replies are publicly visible

Parents

0 sparshs over 7 years ago

I agree with venusaikumarc , you make changes in your database to put up a additional column in your table which will have data from both the columns and that you can define as your primary key. I think that should work.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Reply

0 sparshs over 7 years ago

I agree with venusaikumarc , you make changes in your database to put up a additional column in your table which will have data from both the columns and that you can define as your primary key. I think that should work.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Children

No Data