allsynonyms
Syntax
allsynonyms [[schema_pattern.] object_pattern]
Description
Lists, in a single column, the names of all synonyms that match the
given pattern. When a pattern is missing, the pattern defaults to
"%
".
If passthrough is enabled, lists synonyms on tables matching the pattern in the Oracle database.
Examples
Command> allsynonyms; PUBLIC.ALL_ARGUMENTS PUBLIC.ALL_COL_PRIVS PUBLIC.ALL_DEPENDENCIES PUBLIC.ALL_DIRECTORIES PUBLIC.ALL_ERRORS PUBLIC.ALL_EXTERNAL_TABLES PUBLIC.ALL_IDENTIFIERS PUBLIC.ALL_OBJECTS ….