AdvancedBasic SELECT
Add a CHECK constraint
The query
SQL
ALTER TABLE employees
ADD CONSTRAINT check_salary_positive
CHECK (salary > 0);Note
“Ensures custom business logic at the database level. Any insert/update violating this will fail.
ALTER TABLE employees
ADD CONSTRAINT check_salary_positive
CHECK (salary > 0);Note
“Ensures custom business logic at the database level. Any insert/update violating this will fail.