Export (0) Print
Expand All

sys.key_encryptions (Transact-SQL)

Returns a row for each symmetric key encryption specified by using the ENCRYPTION BY clause of the CREATE SYMMETRIC KEY statement.

Applies to: SQL Server (SQL Server 2008 through current version).

Column names

Data types

Description

key_id

int

ID of the encrypted key.

thumbprint

varbinary(32)

SHA-1 hash of the certificate with which the key is encrypted, or the GUID of the symmetric key with which the key is encrypted.

crypt_type

char(4)

Type of encryption:

ESKS = Encrypted by symmetric key

ESKP = Encrypted by password

EPUC = Encrypted by certificate

EPUA = Encrypted by asymmetric key

ESKM = Encrypted by master key

crypt_type_desc

nvarchar(60)

Description of encryption type:

ENCRYPTION BY SYMMETRIC KEY

ENCRYPTION BY PASSWORD

ENCRYPTION BY CERTIFICATE

ENCRYPTION BY ASYMMETRIC KEY

ENCRYPTION BY MASTER KEY

Note Note

Windows DPAPI is used to protect the service master key.

crypt_property

varbinary(max)

Signed or encrypted bits.

The visibility of the metadata in catalog views is limited to securables that a user either owns or on which the user has been granted some permission. For more information, see Metadata Visibility Configuration.

Was this page helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

ADD
Show:
© 2014 Microsoft