Chapter 3 DBMS Reference Guide

ViewCheck

Option for checking a view. This parameter determines if the With Check Option check box in the view property sheet is available or grayed.

If the check box is selected and the ViewCheck parameter is not empty, the value of ViewCheck is generated at the end of the view select statement and before the terminator.

Example

In Sybase SQL Anywhere 5.5:

ViewCheck = with check option 

The generated script for this example is:

create view TEST as
select CUSTOMER.CUSNUM, CUSTOMER.CUSNAME, CUSTOMER.CUSTEL
from CUSTOMER
with check option;

Copyright (C) 2005. Sybase Inc. All rights reserved.