This topic has not yet been rated - Rate this topic

MasterKey.EnumKeyEncryptions Method

SQL Server 2012

Enumerates a list of the current set of key encryptions for the database master key.

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

Syntax

C++

JScript

public DataTable EnumKeyEncryptions()

Return Value

Type: System.Data.DataTable
A DataTable system object value that contains the list of current key encryptions for the database master key. The table describes the different columns of the returned DataTable.

Column	Data type	Description
Urn	String	The URN string that specifies the referenced master key.
Thumbprint	Byte	The thumbprint byte array that is associated with the master key. For more information, see sys.key_encryptions (Transact-SQL).
SymmetricKeyEncryptionType	String	The symmetric key encryption type. For more information, see SymmetricKeyEncryptionType class.
CryptProperty	Byte	The byte array that describes the crypt property. For more information, see sys.key_encryptions (Transact-SQL).

Examples

Calling Methods

Reference

MasterKey Class

Microsoft.SqlServer.Management.Smo Namespace

Other Resources

Encryption Hierarchy

CREATE MASTER KEY (Transact-SQL)

Did you find this helpful? Yes No

Not accurate

Not enough depth

Need more code examples

(1500 characters remaining)

Community Additions

ADD