Compartilhar via

  • Artigo

Propriedade do RDL Synonyms

Representa uma coleção de objetos Synonym. Cada objeto Synonym representa um sinônimo definido no banco de dados.

Namespace:  Microsoft.SqlServer.Management.Smo
Assembly:  Microsoft.SqlServer.Smo (em Microsoft.SqlServer.Smo.dll)

Sintaxe

'Declaração
<SfcObjectAttribute(SfcContainerRelationship.ObjectContainer, SfcContainerCardinality.ZeroToAny,  _
    GetType(Synonym), SfcObjectFlags.Design)> _
Public ReadOnly Property Synonyms As SynonymCollection
    Get
'Uso
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

Valor da propriedade

Tipo: Microsoft.SqlServer.Management.Smo. . :: . .SynonymCollection
Um objeto SynonymCollection que representa todos os sinônimos definidos no banco de dados.

Comentários

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.

Exemplos

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
}