Why mentioning NOT NULL while applying PRIMARY KEY constraint? | Sololearn: Learn to code for FREE!
New course! Every coder should learn Generative AI!
Try a free lesson
+ 1

Why mentioning NOT NULL while applying PRIMARY KEY constraint?

According to my experience with databases you don't need to do so!

23rd Jun 2019, 3:45 PM
Yasser AKBBACH
Yasser AKBBACH - avatar
2 Answers
0
Just an extra precaution to make sure it always has a value. Can really mess things up otherwise.
23rd Jun 2019, 5:36 PM
Jackson O’Donnell
0
I know what's the meaning of PK, my input was about that PK = NOT NULL + UNIQUE + INDEX why they need to mention NOT NULL twice at the table creation?
23rd Jun 2019, 11:56 PM
Yasser AKBBACH
Yasser AKBBACH - avatar