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
….