how do Primary keys work? | Sololearn: Learn to code for FREE!
New course! Every coder should learn Generative AI!
Try a free lesson
+ 1

how do Primary keys work?

1st Sep 2017, 7:25 AM
Alasta Iphithule Dube
Alasta Iphithule Dube - avatar
1 Answer
+ 7
create table studenttable (st.name varchar (10) ,rollno int primary key); //i have applied primary key on field/column/key " rollno " , u cannot left this column blank //here u cannot add more than 1 record which have same roll no. // actually primary key is used to identify records uniquely //here each records gets unquely idetified as every student have different rollno. in records of table studenttable
1st Sep 2017, 7:31 AM
Changed
Changed - avatar