SQL Server
United States (English) Sign in
Home 2012 2008 R2 2008 Previous Versions Library Forums
TechNet Library
SQL Server
SQL Server 2005
Product Documentation
SQL Server 2005 Documentation
SQL Server 2005 Books Online
SQL Server Programming Reference
Database Engine Administration Programming
SQL Management Objects (SMO)
SMO Managed Programming Reference Documentation
SMO Class Library
Microsoft.SqlServer.Management.Smo
Database Class
Database Properties
ActiveConnections Property
ActiveDirectory Property
ApplicationRoles Property
Assemblies Property
AsymmetricKeys Property
AutoCreateStatisticsEnabled Property
AutoUpdateStatisticsEnabled Property
CaseSensitive Property
Certificates Property
Collation Property
CompatibilityLevel Property
CreateDate Property
DatabaseGuid Property
DatabaseOptions Property
DatabaseSnapshotBaseName Property
DataSpaceUsage Property
DboLogin Property
DefaultFileGroup Property
DefaultFullTextCatalog Property
Defaults Property
DefaultSchema Property
Events Property
ExtendedProperties Property
ExtendedStoredProcedures Property
FileGroups Property
FullTextCatalogs Property
ID Property
IndexSpaceUsage Property
IsAccessible Property
IsDatabaseSnapshot Property
IsDatabaseSnapshotBase Property
IsDbAccessAdmin Property
IsDbBackupOperator Property
IsDbDatareader Property
IsDbDatawriter Property
IsDbDdlAdmin Property
IsDbDenyDatareader Property
IsDbDenyDatawriter Property
IsDbOwner Property
IsDbSecurityAdmin Property
IsFullTextEnabled Property
IsMailHost Property
IsMirroringEnabled Property
IsSystemObject Property
IsUpdateable Property
LastBackupDate Property
LastLogBackupDate Property
LogFiles Property
LogReuseWaitStatus Property
MasterKey Property
MirroringFailoverLogSequenceNumber Property
MirroringID Property
MirroringPartner Property
MirroringPartnerInstance Property
MirroringRoleSequence Property
MirroringSafetyLevel Property
MirroringSafetySequence Property
MirroringStatus Property
MirroringWitness Property
MirroringWitnessStatus Property
Owner Property
Parent Property
PartitionFunctions Property
PartitionSchemes Property
PrimaryFilePath Property
RecoveryForkGuid Property
ReplicationOptions Property
Roles Property
Rules Property
Schemas Property
ServiceBroker Property
ServiceBrokerGuid Property
Size Property
SpaceAvailable Property
Status Property
StoredProcedures Property
SymmetricKeys Property
Synonyms Property
Tables Property
Triggers Property
UserDefinedAggregates Property
UserDefinedDataTypes Property
UserDefinedFunctions Property
UserDefinedTypes Property
UserName Property
Users Property
Version Property
Views Property
XmlSchemaCollections Property
Expand Minimize
This topic has not yet been rated - Rate this topic

Database.Synonyms Property

SQL Server 2005

Represents a collection of Synonym objects. Each Synonym object represents a synonym defined on the database.

Namespace: Microsoft.SqlServer.Management.Smo
Assembly: Microsoft.SqlServer.Smo (in microsoft.sqlserver.smo.dll)
C#
C++
VB
Copy 
public SynonymCollection Synonyms { get; }
J#
Copy 
/** @property */
public SynonymCollection get_Synonyms ()
JScript
Copy 
public function get Synonyms () : SynonymCollection

Property Value

A SynonymCollection object that represents all the synonyms defined on the database.

Updated text: 17 July 2006

Specific synonyms can be referenced by using this collection by specifying the name of the synonym. To add a new synonym to the collection, call the synonym constructor, Synonym.

This namespace, class, or member is supported only in version 2.0 of the Microsoft .NET Framework.


Copy 
Dim srv As Server
        srv = New Server

'Reference the AdventureWorks database.
Dim db As Database
db = srv.Databases("AdventureWorks")

'Display all the synonyms in the database.
Dim sy As Synonym
For Each sy In db.Synonyms
   Console.WriteLine(sy.Name)
Next
Any public static (Shared in Microsoft Visual Basic) members of this type are thread safe. Any instance members are not guaranteed to be thread safe.

Development Platforms

For a list of the supported platforms, see Hardware and Software Requirements for Installing SQL Server 2005.

Target Platforms

Release

History

17 July 2006

Changed content:

  • Added text to the Remarks section.

  • Added code to the Example section.

Did you find this helpful?
(1500 characters remaining)

Community Additions

ADD
© 2013 Microsoft
|
Site Feedback
© 2013 Microsoft. All rights reserved.