SQL Create Synonym

The create synonym statement is used to create a synonym, which is an alternative name (or alias) for a table. Synonyms are supported for tables only. Synonyms provide both data independence and location transparency. Synonyms permit applications to function without modification regardless of which user owns the table or view and regardless of which database holds the table or view.

For example:

 
    create table t (x integer);
    create synonym t2 for t;
            
     

Once created, the synonym can be used in any context where the original table is used.

(To remove a synonym a drop synonym statement is used.)