Progress
SQL-92
Guide and Reference


CREATE SYNONYM Statement

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.

SQL COMPLIANCE

Progress Extension

ENVIRONMENT

Embedded SQL, interactive SQL, ODBC applications, JDBC applications

RELATED STATEMENTS

DROP SYNONYM Statement


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