When you select an alias from the contents
pane and select Show Related for that object,
the Show Related dialog lists any objects
with first-level dependencies on that alias.
These objects can be: tables, views, packages,
plans. You can view second-level dependencies
by selecting Show Related for each object
with a first-level dependency.
Tables and Views
- Dropping an alias has no effect on any view
that is defined using the alias.
- If you drop an alias for a table the table
is not changed.
- If you drop a table, its aliases are not
dropped.
- If you move a table or view, first you must
drop its aliases , then recreate them with
the new location names. If you use three-part
names, remember that three-part names in
applications referring to the table or view
must be changed.
- If you move an application, aliases must
exist at the new location for all tables
referred to by the application. You can drop
aliases at the old location if they are no
longer needed.
Packages and Plans
If you drop an alias that was used in a package
or plan, you need to rebind the package or
plan.
Return to main Show Related help window