Chapter 3 DBMS Reference Guide

Common entries for Synonym

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

Entry Example (Oracle 9i)
Enable 
Enable = Yes
Create 
create [%VISIBILITY% ]synonym [%QUALIFIER%]%SYNONYM% for [%BASEOWNER%]%BASEOBJECT%
Drop 
drop [%VISIBILITY% ]synonym [%QUALIFIER%]%SYNONYM%
SqlListQuery 
{OWNER, SYNONYM, BASEOWNER, BASEOBJECT}
         
[%ISODBCUSER% ?
select 
   %.q:SCHEMA%,
   t.synonym_name, 
   t.table_owner,
   t.table_name
from
   sys.user_synonyms t
order by 
   t.table_name
:
select 
   t.owner,
   t.synonym_name,
   t.table_owner,
   t.table_name
from
   sys.all_synonyms t
where
(1=1)
[  and t.synonym_name=%.q:TABLE%]
[  and t.owner=%.q:SCHEMA%]
order by 
   t.owner, t.synonym_name
]
SqlAttrQuery —

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

 

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