Synonyms in SQL

Synonyms in SQL

Synonyms are the database object which is used to provide an alternative name to other database objects.

Synonym can be used to specify with objects like:

• Tables
• Views
• Stored Procedure
• User-Defined Function

Some points to be remember about synonyms:

1. A synonym cannot refer to another synonym.
2. Synonyms cannot be altered using ALTER statement. To modify the synonym you must DROP it and recreate.

Create Synonym

To create a synonym, simply specify a synonym name and name of database object to which it will be assigned.

Syntax:

Create SYNONYM  [schemaname.]synonymname FOR objectname;

Example:

create synonym suppliers for app.suppliers;

Drop Synonym

Syntax:

DROP SYNONYM synonymname;

Example:

Drop synonym suppliers;