8. SQL Statements : CREATE SYNONYM : Syntax
 
Share this page                  
Syntax
The CREATE SYNONYM statement has the following format:
[EXEC SQL] CREATE SYNONYM synonym_name
              FOR [schema.]object
synonym_name
Specifies a valid object name and must not conflict with the names of other tables, views, indexes, or synonyms owned by the user issuing the statement. Synonyms can be used any place that table, view, or index identifiers are required.