SQL Server 2005 Books Online (November 2008)
Synonyms (Database Engine)

Microsoft SQL Server 2005 introduces the concept of a synonym. A synonym is an alternative name for a schema-scoped object. Client applications can use a single-part name to reference a base object by using a synonym instead of using a two-part, three-part, or four-part name to reference the base object.

This section provides the information that is necessary to understand synonyms.

Topic Description

Understanding Synonyms

Explains the concept of synonyms and the benefits of using synonyms.

Using Synonyms (Database Engine)

Describes the contexts in which synonyms can and cannot be used.

Getting Information About Synonyms

Provides information about accessing synonym metadata and other related information.

Tags :


Community Content

Venkatesan Prabu Jayakantham
Additional Information on Synonyms

1. Synonyms replace fully qualified name into shortest user-defined name to cut down the development time.

2. It provides an abstraction layer to protect you against changes in underlying objects.

3. Synonyms base object will be checked at run time only

Tags :

Page view tracker