GaussDB-DB_SYNONYMS

26 阅读1分钟

GaussDB-DB_SYNONYMS

DB_SYNONYMS displays all synonyms accessible to the current user.

NameTypeDescription
ownertextOwner of a synonym. The owner of the PUBLIC synonym is PUBLIC.
schema_nametextName of the schema to which the synonym belongs. The name of the schema to which the PUBLIC synonym belongs is NULL.
synonym_nametextSynonym name.
table_ownertextOwner of the associated object. Although the column is called table_owner, the associated object is not necessarily a table. It can be any common database object, such as a view, stored procedure, or synonym.
table_nametextName of the associated object. Although the column is called table_name, the associated object is not necessarily a table. It can be any common database object, such as a view, stored procedure, or synonym.
table_schema_nametextSchema name of the associated object. Although the column is called table_schema_name, the associated object is not necessarily a table. It can be any common database object, such as a view, stored procedure, or synonym.
db_linkcharacter varying(128)Reserved column. The value is NULL.
origin_con_idcharacter varying(256)Not supported. The value is 0.

更多详情请参考GaussDB 文档中心:doc.hcs.huawei.com/db/zh-cn/ga…