Bright Tutorials Bright Tutorials
CBSE Class 12 Computer Science Question 11 of 79

Table Creation and Data Manipulation Commands — Question 5

Back to all questions
5
Question

Question 5

What is NOT NULL constraint ? What is DEFAULT constraint ?

Answer

The NOT NULL constraint is used in SQL to ensure that a column cannot contain NULL (i.e., empty) values.

A DEFAULT constraint is used in SQL to specify a default value for a column in a table. When the user does not enter a value for the column (having default value), automatically the defined default value is inserted in the field.