what if we have table and we want to make any colomn primary key? | Sololearn: Learn to code for FREE!
New course! Every coder should learn Generative AI!
Try a free lesson
0

what if we have table and we want to make any colomn primary key?

17th Dec 2016, 3:27 PM
Aqib Asmat
Aqib Asmat - avatar
2 Answers
+ 2
Use the following query: ALTER TABLE tableName ADD PRIMARY KEY(keyName)
17th Dec 2016, 4:02 PM
Mayank Chauhan
Mayank Chauhan - avatar
0
when i write colomn name in primary key(colomn name) it gives me error of not correct data type how i mention the colomn name?
17th Dec 2016, 6:48 PM
Aqib Asmat
Aqib Asmat - avatar