Release 10.1A: OpenEdge Data Management:
SQL Reference

> ## CREATE SYNONYM

> Creates a synonym for the specified table, view, or synonym. A synonym is an alias that SQL statements can use instead of the name specified when the table, view, or synonym was created.

> #### Syntax

>     CREATE [ PUBLIC ] SYNONYM synonym
>       FOR [ owner_name.] {table_name | view_name  | synonym } ;

> `PUBLIC`

> Specifies that the synonym is public: all users can refer to the name without qualifying it. By default, the synonym is private: other users must qualify the synonym by preceding it with the user name of the user who created it.

> Users must have the DBA privilege to create public synonyms.

> `SYNONYM synonym`

> Name for the synonym.

> `FOR [ owner_name.] { table_name | view_name | synonym }`

> Table, view, or synonym for which SQL creates the new synonym.

> Example

>     CREATE SYNONYM customer FOR smith.customer ;
>     CREATE PUBLIC SYNONYM public_suppliers FOR smith.suppliers ;

> ##### Authorization

> Must have `DBA` privilege or `RESOURCE` privilege.

> ##### RELATED STATEMENT

> DROP SYNONYM

Copyright © 2005 Progress Software Corporation www.progress.com Voice: (781) 280-4000 Fax: (781) 280-4095