Skip to content

Latest commit

 

History

History
55 lines (49 loc) · 3.66 KB

sys-asymmetric-keys-transact-sql.md

File metadata and controls

55 lines (49 loc) · 3.66 KB
title description author ms.author ms.date ms.service ms.subservice ms.topic f1_keywords helpviewer_keywords dev_langs monikerRange
sys.asymmetric_keys (Transact-SQL)
sys.asymmetric_keys (Transact-SQL)
rwestMSFT
randolphwest
06/10/2016
sql
system-objects
reference
asymmetric_keys
sys.asymmetric_keys_TSQL
asymmetric_keys_TSQL
sys.asymmetric_keys
sys.asymmetric_keys catalog view
TSQL
=azuresqldb-current||>=sql-server-2016||>=sql-server-linux-2017||=azuresqldb-mi-current

sys.asymmetric_keys (Transact-SQL)

[!INCLUDE SQL Server Azure SQL Database Azure SQL Managed Instance]

Returns a row for each asymmetric key.

Column name Data type Description
name sysname Name of the key. Is unique within the database.
principal_id int ID of the database principal that owns the key.
asymmetric_key_id int ID of the key. Is unique within the database.
pvt_key_encryption_type char(2) How the key is encrypted.

NA = Not encrypted

MK = Key is encrypted by the master key

PW = Key is encrypted by a user-defined password

SK = Key is encrypted by service master key.
pvt_key_encryption_type_desc nvarchar(60) Description of how the private key is encrypted.

NO_PRIVATE_KEY

ENCRYPTED_BY_MASTER_KEY

ENCRYPTED_BY_PASSWORD

ENCRYPTED_BY_SERVICE_MASTER_KEY
thumbprint varbinary(32) SHA-1 hash of the key. The hash is globally unique.
algorithm char(2) Algorithm used with the key.

1R = 512-bit RSA

2R = 1024-bit RSA

3R = 2048-bit RSA
algorithm_desc nvarchar(60) Description of the algorithm used with the key.

RSA_512

RSA_1024

RSA_2048
key_length int Bit length of the key.
sid varbinary(85) Login SID for this key. For Extensible Key Management keys this value will be NULL.
string_sid nvarchar(128) String representation of the login SID of the key. For Extensible Key Management keys this value will be NULL.
public_key varbinary(max) Public key.
attested_by nvarchar(260) System use only.
provider_type nvarchar(120) Type of cryptographic provider:

CRYPTOGRAPHIC PROVIDER = Extensible Key Management keys

NULL = Non-Extensible Key Management keys
cryptographic_provider_guid uniqueidentifier GUID for the cryptographic provider. For non-Extensible Key Management keys this value will be NULL.
cryptographic_provider_algid sql_variant Algorithm ID for the cryptographic provider. For non-Extensible Key Management keys this value will be NULL.

Permissions

[!INCLUDEssCatViewPerm] For more information, see Metadata Visibility Configuration.

See Also

Security Catalog Views (Transact-SQL)
Extensible Key Management (EKM)
Catalog Views (Transact-SQL)
Encryption Hierarchy
CREATE ASYMMETRIC KEY (Transact-SQL)