Export (0) Print
Expand All
Expand Minimize

Database.Certificates Property

Represents a collection of Certificate objects. Each Certificate object represents a certificate defined on the database.

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

[SfcObjectAttribute(SfcContainerRelationship.ObjectContainer, SfcContainerCardinality.ZeroToAny, 
	typeof(Certificate))]
public CertificateCollection Certificates { get; }

Property Value

Type: Microsoft.SqlServer.Management.Smo.CertificateCollection
A CertificateCollection object that represents all the certificates defined on the database.

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.

'Connect to the local, default instance of SQL Server.
Dim srv As Server
srv = New Server

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

'Display all the asymmetric keys on the database.
Dim ak As AsymmetricKey
For Each ak In db.AsymmetricKeys
   Console.WriteLine(ak.Name)
Next
Was this page helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

ADD
Show:
© 2015 Microsoft