3

Is it unnecessary to have both a default value and a not null constraint in defining an SQL column?

edit

• sql

asked 2023-04-03 11:00:00 +0000

huitzilopochtli
41 ●4 ●3

edit retag flag offensive close merge delete

add a comment

3

answered 2022-03-21 05:00:00 +0000

devzero
51 ●1 ●4 ●4

It is not necessary to have both a default value and a not null constraint in defining an SQL column. When a default value is set for a column, it automatically implies that the column cannot be null. However, it is good practice to explicitly define the not null constraint for clarity and to ensure data integrity.

edit flag offensive delete link more

add a comment

Your Answer

Please start posting anonymously - your entry will be published after you log in or create a new account. This space is reserved only for answers. If you would like to engage in a discussion, please instead post a comment under the question or an answer that you would like to discuss