Synonyms (Database Engine)

Switch on low bandwidth view

Community Content

In this section

Statistics Annotations (1)

Click here to expand

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

: Add a tag

Community Content

Add new content

Annotations

Additional Information on Synonyms

Venkatesan Prabu Jayakantham | Edit | Show History

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