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.
| 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 |
crypt_property |
varbinary(max) |
Signed or encrypted bits. |
See Also
Reference
Catalog Views (Transact-SQL)
Security Catalog Views (Transact-SQL)
CREATE SYMMETRIC KEY (Transact-SQL)