When you select a synonym from the contents
pane and select Show Related for that object,
the Show Related dialog lists any objects
with first-level dependencies on that synonym.
These objects can be: packages, plans, tables,
and views. You can view second-level dependencies
by selecting Show Related for each object
with a first-level dependency.
Packages, Plans
Dropping a synonym has no effect on any view
or alias that was defined using the synonym,
nor does it invalidate any plans or packages
that use such views or aliases.
Tables, Views
-
You can create a synonym for an alias that
refers to a local table or view, but not
for an alias that refers to an object from
a remote DB2 subsystem. However, if an alias
is used to denote the table or view, the
name of that table or view, not the alias,
is recorded in the catalog as the definition
of the synonym. The connection between the
synonym and alias is severed, and even if
the alias is dropped and redefined, the synonym
is still in effect and names the original
table or view.
- Dropping a synonym has no effect on any view,
alias, or table that is defined using the
synonym.
Return to main Show Related help window