Chapter 3 DBMS Reference Guide


Variables for views

Variable name Comment
VIEW Generated code of View
VIEWNAME View name
VIEWCODE View code
VIEWCOLN List of columns of View. Ex: "A, B, C"
SQL SQL text of View. Ex: Select * from T1
VIEWCHECK Contains Keyword "with check option" if this option is selected in View
SCRIPT Complete view creation order. Ex: create view V1 as select * from T1

 


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