| Oracle® Database Reference 11g Release 2 (11.2) Part Number E25513-03 | 
 | 
| 
 | PDF · Mobi · ePub | 
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 |