How do I change the primary key of my SQL data base?

I set the primary key of my SQL DataBase to First_Name, Last_Name, Birth_Date.

So, the records are in First_Name, Last_Name sequence.

I want the sequence to be Last_Name, First_Name.

How do I change it

Answer this question

How do I change the primary key of my SQL data base?

Sunrise828
I meant the sequence of the records in the file.
AboOmar

Hi,

As per my understanding of what you explained, you can select each field in your own order in the SQL Query. hope this helps.

Thank you,
Bhanu.
MaNicXs

hi,

first of all primary key doesn't have anything to do with your columns sequence

the columns sequence depend on your design wich column you want it to be the first one

the last thing is that you can't depend on firstname , lastname, birthdate to be primary keys at all because names can be duplicated and you might have 2 persons have the same name or birth date

hope this helps
frasiec

Hello,

FYI: If you think that your post is answered, then could you please mark it answer[Click on Mark as Answer button] so that the member's of the forum will know that your post is answered.

Thank you,
Bhanu.
How do I change the primary key of my SQL data base?

Answer this question