Why mentioning NOT NULL while applying PRIMARY KEY constraint? | Sololearn: Learn to code for FREE!
¡Nuevo curso! ¡Todo programador debería aprender IA Generativa!
Prueba una lección gratuita
+ 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 Respuestas
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