Chapter 3 DBMS Resource File Reference


Variables for views

Variable 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) 2008. Sybase Inc. All rights reserved.