Using Synonyms

A synonym is an alternative name for a schema-scoped object. In SMO, synonyms are represented by the Synonym object. The Synonym object is a child of the Database object. This means that synonyms are valid only within the scope of the database in which they are defined. However, the synonym can refer to objects on another database, or on a remote instance of SQL Server.

The object that is given an alternative name is known as the base object. The name property of the Synonym object is the alternative name given to the base object.

See Also

Other Resources

Using Synonyms (Database Engine)
CREATE SYNONYM (Transact-SQL)
Designing and Creating Databases

Help and Information

Getting SQL Server 2005 Assistance