SQL Language Guide > SQL Language Guide > SQL Statements > CREATE SYNONYM
Was this helpful?
CREATE SYNONYM
Valid in: Valid in: SQL, ESQL, DBProc, OpenAPI, ODBC, JDBC, .NET
The CREATE SYNONYM statement defines a synonym for a table, view, or index. A synonym is an alias (alternate name) for an object.
This statement has the following format:
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.
Last modified date: 11/09/2022