what if we have table and we want to make any colomn primary key? | Sololearn: Learn to code for FREE!
Новый курс! Каждый программист должен знать генеративный ИИ!
Попробуйте бесплатный урок
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 ответов
+ 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