![]() ![]() To address both these issues, you can create a synonym, EmpTable, on Server2 for the Employee table on Server1. Also, if the location of the table were to change, for example, to another server, the client application would have to be modified to reflect that change. To reference this table from another server, Server2, a client application would have to use the four-part name. Provides a layer of abstraction that protects a client application from changes made to the name or location of the base object.įor example, consider the Employee table of Adventure Works, located on a server named Server1. Provides an alternative name for another database object, referred to as the base object, that can exist on a local or remote server. ![]() A synonym is a database object that serves the following purposes:
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |