Chapter 3 DBMS Reference Guide

Common entries for View

You can define values for the following common entries for the view object in the DBMS definition.

Entry Example (Oracle 8)
Enable Enable = Yes
Create 
create [or replace ][%R% [no] force]view [%QUALIFIER%]%VIEW% [(%VIEWCOLN%) ]as
%SQL%
[%VIEWCHECK%] [%R%with read only]
Drop 
drop view [%QUALIFIER%]%VIEW%
SqlListQuery —
SqlAttrQuery 
{OWNER, VIEW, SCRIPT}

[%ISODBCUSER% ?
SELECT '%SCHEMA%', VIEW_NAME, TEXT
FROM SYS.USER_VIEWS
ORDER BY VIEW_NAME
:
SELECT OWNER, VIEW_NAME, TEXT
FROM SYS.ALL_VIEWS [WHERE OWNER='%SCHEMA%']
ORDER BY OWNER, VIEW_NAME
]
SqlFragQuery 
{VAR1NAME, VAR1VALUE}

select
   'HighVal'||tp.partition_position,
   tp.high_value
from
   all_tab_partitions tp
where 1=1
[  and tp.table_owner=%.q:OWNER% ]
[  and tp.table_name=%.q:VIEW%]
SqlOptsQuery —
Options —
ModifiableAttributes List of extended attributes that will be taken into account in the merge dialog box during database synchronization
ReversedStatements List of statements that will be reverse engineered

For a description of each of the common object entries, see section "Common object entries".

 

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