Help Center/ Data Warehouse Service / Standard Data Warehouse (9.1.0.x)/ DWS System Catalogs and Views/ System Views/ ALL_SYNONYMS
Updated on 2025-10-09 GMT+08:00
View PDF

ALL_SYNONYMS

ALL_SYNONYMS displays all synonyms accessible to the current user.

Table 1 ALL_SYNONYMS columns

Column

Type

Description

owner

Text

Owner of a synonym

schema_name

Text

Name of the schema to which the synonym belongs

synonym_name

Text

Synonym name

table_owner

Text

Owner of the associated object

table_schema_name

Text

Name of the schema the associated object belongs to

table_name

Text

Name of the associated object
Parent Topic: System Views