PUBLICSYN contains information on public synonyms.
| Column | Datatype | NULL | Description |
|---|---|---|---|
SNAME |
VARCHAR2(30) |
Name of the synonym | |
CREATOR |
VARCHAR2(30) |
Owner of the synonym | |
TNAME |
VARCHAR2(30) |
Table of which this is a synonym | |
DATABASE |
VARCHAR2(128) |
Database in which the table resides | |
TABTYPE |
VARCHAR2(9) |
Type of table |