Database Reference
In-Depth Information
Figure 11-19.
The Alter-Sequence Statement
A sequence may be removed via the
Drop-Sequence
command, which has the
following syntax:
11.11 Creating and Managing Synonyms
A synonym is a virtual object (i.e. the alias of an object), used to fulfill any or both of the
following purposes:
•
Shortening the length of an object's name
•
Referring to an object (typically a table) owned by another
schema (user)
The
Create-Synonym
command has the following syntax:
Note
: If the synonym is public (created with keyword PUBLIC), other users have
access to it; otherwise, it is private to the user who created it. Synonym, as used here,
corresponds to the term “alias”, as used in Chapter 7.
Example 12:
The following example creates a synonym called
ValidDate
for an
object of the same name in another schema: