ALLBASE/SQL Reference Manual (36216-90216)

370 Chapter10
SQL Statements A - D
CREATE VIEW
If the table on which the view is based has any check constraints of its own, these
conditions are checked along with the WITH CHECK OPTION of the view.
CREATE VIEW RecDB.EventView
(Event,
Date)
AS SELECT RecDB.Event,
RecDB.Date
FROM RecDB.Events
WHERE Date >= CURRENT_DATE
WITH CHECK OPTION CONSTRAINT EventView_WCO