Share via


Synonym Properties

These properties are displayed in the Properties window when you select a synonym in Server Explorer. Unless otherwise noted, these properties apply only to SQL Server 2005 and SQL Server 2008.

Note

The properties in this topic are ordered by category rather than alphabet.

Note

Your computer might show different names or locations for some of the Visual Studio user interface elements in the following instructions. The Visual Studio edition that you have and the settings that you use determine these elements. For more information, see Customizing Development Settings in Visual Studio.

  • Identity Category
    Expands to show the properties for Name, Database, and Schema.

  • Name
    Shows the name of the selected synonym. (This applies to SQL Server 2005, SQL Server 2008, and Oracle.)

  • Database
    Shows the name of the database with which the synonym is associated.

  • Schema
    Shows the name of the schema to which this synonym belongs.

  • Misc Category
    Expands to show the remaining properties.

  • Owner
    Identifies the object the synonym refers to. (This applies only to Oracle.)

  • Base Database
    Shows the database where the object the synonym refers to (the base object) resides.

  • Base Object Name
    Shows the name of the base object. (This applies to SQL Server 2005, SQL Server 2008, and Oracle.)

  • Base Object Type
    Shows the type of object the synonym is based on, such as a view or table.

  • Base Schema
    Shows the name of the schema for the base object.

  • Base Server
    Shows the name of the server where the database for the base object resides.

  • Referenced Type
    Shows the type of object the synonym represents. (This applies only to Oracle.)

See Also

Other Resources

Properties in Visual Database Tools