Chapter 3 DBMS Reference Guide
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) 2005. Sybase Inc. All rights reserved. |