Data Integrity via WITH CHECK OPTION

Snippet

Data Integrity via WITH CHECK OPTION

The WITH CHECK OPTION clause on a view prevents users from inserting or updating rows that would not be visible through the view itself. This enforces business logic at the schema level, ensuring data consistency for updatable views.

snippet.sql
sql
CREATE VIEW Active_Staff AS
SELECT id, name, status
FROM Employees
WHERE status = 'ACTIVE'
WITH CHECK OPTION;

Breakdown

WHERE status = 'ACTIVE'

Defines the filter criteria for the view's contents.

WITH CHECK OPTION

Mandates that any DML operation via this view must satisfy the WHERE clause.

Previous snippet Next snippet

More Expert SQL exercises →

From your library

Data Integrity via WITH CHECK OPTION

Related