Why mentioning NOT NULL while applying PRIMARY KEY constraint? | Sololearn: Learn to code for FREE!
Neuer Kurs! Jeder Programmierer sollte generative KI lernen!
Kostenlose Lektion ausprobieren
+ 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 Antworten
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