Propriedade do RDL AsymmetricKeys
Representa uma coleção de objetos AsymmetricKey. Cada objeto AsymmetricKey representa uma chave assimétrica definida 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(AsymmetricKey))> _
Public ReadOnly Property AsymmetricKeys As AsymmetricKeyCollection
Get
'Uso
Dim instance As Database
Dim value As AsymmetricKeyCollection
value = instance.AsymmetricKeys
[SfcObjectAttribute(SfcContainerRelationship.ObjectContainer, SfcContainerCardinality.ZeroToAny,
typeof(AsymmetricKey))]
public AsymmetricKeyCollection AsymmetricKeys { get; }
[SfcObjectAttribute(SfcContainerRelationship::ObjectContainer, SfcContainerCardinality::ZeroToAny,
typeof(AsymmetricKey))]
public:
property AsymmetricKeyCollection^ AsymmetricKeys {
AsymmetricKeyCollection^ get ();
}
[<SfcObjectAttribute(SfcContainerRelationship.ObjectContainer, SfcContainerCardinality.ZeroToAny,
typeof(AsymmetricKey))>]
member AsymmetricKeys : AsymmetricKeyCollection
function get AsymmetricKeys () : AsymmetricKeyCollection
Valor da propriedade
Tipo: Microsoft.SqlServer.Management.Smo. . :: . .AsymmetricKeyCollection
Um objeto AsymmetricKeyCollection que representa todas as chaves assimétricas definidas no banco de dados.
Comentários
Specific asymmetric keys can be referenced by using this collection by specifying the name of the asymmetric key. To add a new asymmetric key to the collection, call the asymmetric key constructor AsymmetricKey.
Exemplos
VB
'Connect to the local, default instance of SQL Server.
Dim srv As Server
srv = New Server
'Reference the AdventureWorks2008R2 database.
Dim db As Database
db = srv.Databases("AdventureWorks2008R2")
'Display all the asymmetric keys on the database.
Dim ak As AsymmetricKey
For Each ak In db.AsymmetricKeys
Console.WriteLine(ak.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 ($ak in $db.AsymmetricKeys)
{
Write-Host $ak.Name
}