Synonyms
Go Up to Supported Objects
The function and usage of synonyms differs by DBMS platform
|
DB2 z/OS |
An alternate name for an existing table, view, or alias. |
|
Oracle |
An alternative name for a table, view, sequence, procedure, function, package, materialized view, java class, type, or another synonym. |
|
SQL Server |
A single-part name used to reference multi-part names in SQL statements. While synonyms can be created for functions, procedures, tables, and views, consult Microsoft SQL Server documentation for restrictions on function and procedure support. For more information, see Accessing Third Party Documentation. |
Creating and editing
- Synonyms Wizard (DB2 Z/OS) and Synonyms Editor (IBM DB2 Z/OS)
- Synonyms Wizard (Oracle) and Synonyms Editor (Oracle)
- Synonyms Wizard (SQL Server) and Synonyms Editor (SQL Server)
DBMS platform availability and object actions/operations supported
The following table lists object actions available for this object type. For an introduction to object actions and details on usage of specific actions, see Object actions.
| DB2 z/OS | ORCL | SQL SVR | |
|---|---|---|---|
|
✓ |
|||
|
✓ |
|||
|
✓ |
✓ |
✓ | |
|
✓ |
✓ |
✓ | |
|
✓ |
✓ |
✓ | |
|
✓ |
✓ | ||
|
✓ |
✓ |
✓ |