Enforcing Logic via WITH CHECK OPTION

Snippet

Enforcing Logic via WITH CHECK OPTION

The WITH CHECK OPTION ensures that any INSERT or UPDATE performed through the view must satisfy the view's WHERE clause. Using CASCADED extends this enforcement to all underlying views, preventing 'ghost' updates where data is modified but becomes invisible to the view.

snippet.sql
sql
CREATE VIEW high_value_orders AS
SELECT order_id, customer_id, total_amount
FROM orders
WHERE total_amount > 1000
WITH CASCADED CHECK OPTION;

Breakdown

CREATE VIEW high_value_orders AS

Defines a new virtual table (view) named high_value_orders.

WHERE total_amount > 1000

The logical constraint that filtered data must exceed 1000.

WITH CASCADED CHECK OPTION;

Enforces that any modification through this view must still satisfy the WHERE clause and all underlying view conditions.

Previous snippet Next snippet

More Expert SQL exercises →

From your library

Enforcing Logic via WITH CHECK OPTION

Related