The Synonym object is an alternate name for a table. Synonyms can be defined for base or view tables. They are visible only to their owner.
Relationship between a synonym and other objects:
1. Synonym Refers to Snapshot
2. Synonym Refers to Table
3. Synonym Refers to View
4. Easycommand Uses Synonym
5. Easyform Uses Synonym
6. Module Uses Synonym
7. Qpcommand Uses Synonym
8. Qpquery Uses Synonym
9. Querycommand Uses Synonym
10. Snapshot Uses Synonym
11. View Uses Synonym
1. A synonym refers to a table; a number of synonym definitions can be assigned to a table (N[0]-1).
2. A synonym can refer to a view table; a number of synonym definitions can exist for a view table (N[0]-1[0]).
3. A synonym can refer to a snapshot; a number of synonym definitions can exist for a snapshot (N[0]-1[0]).
4. An EASY command can use a number of synonyms; a synonym can be used by a number of EASY commands (N[0]-M[0]).
5. An EASY form can use a number of synonyms; a synonym can be used by a number of EASY forms (N[0]-M[0]).
6. A module can use a number of synonyms; a synonym can be used by a number of modules (N[0]-M[0]).
7. A QueryPlus command can use a number of synonyms; a synonym can be used by a number of QueryPlus commands (N[0]-M[0]).
8. A QueryPlus query can be used by a number of synonyms; a synonym can be used by a number of QueryPlus queries (N[0]-M[0]).
9. A QUERY command can use a number of synonyms; a synonym can be used by a number of QUERY commands (N[0]-M[0]).
10. A snapshot can use a number of synonyms; a synonym can be used by a number of snapshots (N[0]-M[0]).
11. A view table can be used by a number of synonyms; a synonym can be used by a number of view tables (N[0]-M[0]).
The Synonym object identifies a subset of the Table object. If you wish to obtain information on the table attributes of a synonym table, you can display the Columns associated with the synonym table in the list of tables by selecting the Relships / Object Usage / Columns menu function (see Section Table). If you wish to create a synonym table or obtain a list of all synonyms, enter the Synonym list and select New or the corresponding toolbar button.
From the synonym list, select the Object / Design function or click on the 
toolbar button to activate the synonym definition which, however, contains only the name of the
base table.
See also: