Synonyms can be created for the following types of objects: SQL Server checks for the existence of the base object at run time. The base object need not exist at synonym create time. Is the name of the base object that the synonym references.Īzure SQL Database supports the three-part name format database_name.object_name when the database_name is the current database or the database_name is tempdb and the object_name starts with #. If schema_name is not specified the default schema of the current user is used. Is the name of the schema of the base object. If database_name is not specified, the name of the current database is used. Is the name of the database in which the base object is located. ![]() ![]() Is the name of the server on which base object is located. ![]() If schema is not specified, SQL Server uses the default schema of the current user. Specifies the schema in which the synonym is created. To view Transact-SQL syntax for SQL Server 2014 and earlier, see Previous versions documentation.
0 Comments
Leave a Reply. |
Details
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |