Make your writing more interesting, beautiful, and successful. Synonyms, antonyms, definitions, and example sentences help you find the right word quickly. Developed from Merriam-Webster dictionary, the most trustworthy authority on American English. The world’s largest and most trusted free online thesaurus. For over 20 years, Thesaurus.com has been helping millions of people improve their mastery of the English language and find the precise word with over 3 million synonyms and antonyms.

• Synonyms
• Important Synonym
• Synonyms And Antonyms Finders Dictionary

Synonym search engine powered by WordHippo. Find similar words and phrases with our powerful synonym search engine. Synonym Finder: find it: Synonym. Sononym is a sample browser that offers a fresh perspective on how sounds can be explored and organized. The software is available for Windows, Linux and Mac OS X. A synonym is an alternative name for objects such as tables, views, sequences, stored procedures, and other database objects. You generally use synonyms when you are granting access to an object from another schema and you don't want the users to have to worry about knowing which schema owns the object.

This Oracle tutorial explains how to create and drop synonyms in Oracle with syntax and examples.

Description

A synonym is an alternative name for objects such as tables, views, sequences, stored procedures, and other database objects.

You generally use synonyms when you are granting access to an object from another schema and you don't want the users to have to worry about knowing which schema owns the object.

Create Synonym (or Replace)

You may wish to create a synonym so that users do not have to prefix the table name with the schema name when using the table in a query.

Syntax

The syntax to create a synonym in Oracle is:

OR REPLACE

Allows you to recreate the synonym (if it already exists) without having to issue a DROP synonym command.

PUBLIC

It means that the synonym is a public synonym and is accessible to all users. Remember though that the user must first have the appropriate privileges to the object to use the synonym.

schema

The appropriate schema. If this phrase is omitted, Oracle assumes that you are referring to your own schema.

object_name

The name of the object for which you are creating the synonym. It can be one of the following:

• table
• view
• sequence
• stored procedure
• function
• package
• materialized view
• java class schema object
• user-defined object
• synonym

Example

Let's look at an example of how to create a synonym in Oracle.

Synonyms

For example:

This first CREATE SYNONYM example demonstrates how to create a synonym called suppliers. Now, users of other schemas can reference the table called suppliers without having to prefix the table name with the schema named app. For example:

If this synonym already existed and you wanted to redefine it, you could always use the OR REPLACE phrase as follows:

Drop synonym

Once a synonym has been created in Oracle, you might at some point need to drop the synonym.

Syntax

The syntax to drop a synonym in Oracle is:

PUBLIC

Allows you to drop a public synonym. If you have specified PUBLIC, then you don't specify a schema.

force

It will force Oracle to drop the synonym even if it has dependencies. It is probably not a good idea to use force as it can cause invalidation of Oracle objects.

Example

Important Synonym

Let's look at an example of how to drop a synonym in Oracle.

For example:

Synonyms And Antonyms Finders Dictionary

This DROP statement would drop the synonym called suppliers that we defined earlier.