Propriété Certificates
Représente une collection d'objets Certificate. Chaque objet Certificate représente un certificat défini sur la base de données.
Espace de noms : Microsoft.SqlServer.Management.Smo
Assembly : Microsoft.SqlServer.Smo (en Microsoft.SqlServer.Smo.dll)
Syntaxe
'Déclaration
<SfcObjectAttribute(SfcContainerRelationship.ObjectContainer, SfcContainerCardinality.ZeroToAny, _
GetType(Certificate))> _
Public ReadOnly Property Certificates As CertificateCollection
Get
'Utilisation
Dim instance As Database
Dim value As CertificateCollection
value = instance.Certificates
[SfcObjectAttribute(SfcContainerRelationship.ObjectContainer, SfcContainerCardinality.ZeroToAny,
typeof(Certificate))]
public CertificateCollection Certificates { get; }
[SfcObjectAttribute(SfcContainerRelationship::ObjectContainer, SfcContainerCardinality::ZeroToAny,
typeof(Certificate))]
public:
property CertificateCollection^ Certificates {
CertificateCollection^ get ();
}
[<SfcObjectAttribute(SfcContainerRelationship.ObjectContainer, SfcContainerCardinality.ZeroToAny,
typeof(Certificate))>]
member Certificates : CertificateCollection
function get Certificates () : CertificateCollection
Valeur de propriété
Type : Microsoft.SqlServer.Management.Smo. . :: . .CertificateCollection
Objet CertificateCollection qui représente tous les certificats définis sur la base de données.
Notes
Specific certificates can be referenced by using this collection by specifying the name of the certificate. To add a new certificate to the collection, call the certificate constructor Certificate.
Exemples
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
}
Voir aussi