SALES: 1-800-867-1380

CREATE SYNONYM (Azure SQL Database)

This topic is OBSOLETE. You can find the most current version in the SQL 14 Transact-SQL Reference.

ImportantImportant
This topic is not maintained. For the current version, see CREATE SYNONYM (Transact-SQL).

Creates a synonym, which is an alternative name for a table, view, or other database object.

Syntax Conventions (Azure SQL Database)


CREATE SYNONYM [ schema_name_1. ] synonym_name FOR < object >< object > :: =
{
    [database_name. [ schema_name_2 ].| schema_name_2. ] object_name
}

This syntax diagram demonstrates the supported arguments and function types in Microsoft Microsoft Azure SQL Database.

noteNote
Microsoft Azure SQL Database supports the three-part name format database_name.[schema_name].object_name when the database_name is the current database or the database_name is tempdb and the object_name starts with #.

Microsoft Azure SQL Database does not support four-part names.

For more information about the arguments and the CREATE SYNONYM statement, see CREATE SYNONYM (Transact-SQL) in SQL Server Books Online.

Was this page helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

ADD
Show:
© 2014 Microsoft