Question: The NOT NULL Constraint
Explore how to apply the NOT NULL constraint to SQL table columns, making fields such as employee names and salaries mandatory. This lesson helps you modify table structure to maintain essential data and prepare for interview questions on SQL constraints.
We'll cover the following...
We'll cover the following...
Question
Given the following Employees table structure:
Employees
EmpID | EmpName | Salary |
1 | Susan Lee | 50000.00 |
2 | Alexa Smith | 60000.00 |
3 | Dana Amberson | 45000.00 |
4 | Sarah Ronald | 47000.00 |
Additional information
You are provided with a table named Employees ...