Synonyms

From DBArtisan
Jump to: navigation, search

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

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

Create Synonym

Describe

Drop

Extract

Migrate

Rename

Report