Synonyms Propiedad
Representa una colección de objetos Synonym. Cada objeto Synonym representa un sinónimo definido en la base de datos.
Espacio de nombres: Microsoft.SqlServer.Management.Smo
Ensamblado: Microsoft.SqlServer.Smo (en Microsoft.SqlServer.Smo.dll)
Sintaxis
'Declaración
<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 de la propiedad
Tipo: Microsoft.SqlServer.Management.Smo. . :: . .SynonymCollection
Objeto SynonymCollection que representa todos los sinónimos definidos en la base de datos.
Comentarios
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.
Ejemplos
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
}