Introduction and Explanation to SYNONYM(blog.sqlauthority.com)
submitted by
pinaldave(9662) 4 years, 4 months ago
DBA have been referencing database objects in four part names. SQL Server 2005 introduces the concept of a synonym. A synonyms is a single-part name which can replace multi part name in SQL Statement. Use of synonyms cuts down typing long multi part server name and can replace it with one synonyms. It also provides an abstractions layer which will protect SQL statement using synonyms from changes in underlying objects (tables etc).
|category: Database
|Views: 1
tags:
SQLAuthority pinaldave SQLServer Database SQL another
Everyones tags:
Your Tags: