Aracılığıyla paylaş

  • Makale

Database.Synonyms Özelliği

Temsil eden bir koleksiyon , Synonym nesneler.Her Synonym nesnesini temsil eden bir eş tanımlanan veritabanı.

Ad Alanı:  Microsoft.SqlServer.Management.Smo
Derleme:  Microsoft.SqlServer.Smo (Microsoft.SqlServer.Smo içinde.dll)

Sözdizimi

'Bildirim
<SfcObjectAttribute(SfcContainerRelationship.ObjectContainer, SfcContainerCardinality.ZeroToAny,  _
    GetType(Synonym), SfcObjectFlags.Design)> _
Public ReadOnly Property Synonyms As SynonymCollection
    Get
'Kullanım
Dim instance As Database
Dim value As SynonymCollection

value = instance.Synonyms

[SfcObjectAttribute(SfcContainerRelationship.ObjectContainer, SfcContainerCardinality.ZeroToAny, 
    typeof(Synonym), SfcObjectFlags.Design)]
public SynonymCollection Synonyms { get; }

[SfcObjectAttribute(SfcContainerRelationship::ObjectContainer, SfcContainerCardinality::ZeroToAny, 
    typeof(Synonym), SfcObjectFlags::Design)]
public:
property SynonymCollection^ Synonyms {
    SynonymCollection^ get ();
}

[<SfcObjectAttribute(SfcContainerRelationship.ObjectContainer, SfcContainerCardinality.ZeroToAny, 
    typeof(Synonym), SfcObjectFlags.Design)>]
member Synonyms : SynonymCollection

function get Synonyms () : SynonymCollection

Özellik Değeri

Tür: Microsoft.SqlServer.Management.Smo.SynonymCollection
A SynonymCollection nesnesini temsil eden tüm eşanlamlı tanımlı veritabanı.

Açıklamalar

Belirli eşanlamlı başvuru yapabilirsiniz bunu kullanarak koleksiyon eş adını belirterek.Yeni bir eş için eklemek için koleksiyon, eş kurucusunu Synonym.

Örnekler

VB

Dim srv As Server
        srv = New Server

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

'Display all the synonyms in the database.
Dim sy As Synonym
For Each sy In db.Synonyms
   Console.WriteLine(sy.Name)
Next

PowerShell

$srv = new-Object Microsoft.SqlServer.Management.Smo.Server("(local)")
$db = New-Object Microsoft.SqlServer.Management.Smo.Database
$db = $srv.Databases.Item("AdventureWorks2008R2")

Foreach ($sy in $db.Synonyms)
{
   Write-Host $sy.Name
}