title: "sys.asymmetric_keys (Transact-SQL) | Microsoft Docs" ms.custom: "" ms.date: "06/10/2016" ms.prod: "sql" ms.prod_service: "database-engine, sql-database" ms.service: "" ms.component: "system-catalog-views" ms.reviewer: "" ms.suite: "sql" ms.technology:
- "database-engine" ms.tgt_pltfrm: "" ms.topic: "language-reference" f1_keywords:
- "asymmetric_keys"
- "sys.asymmetric_keys_TSQL"
- "asymmetric_keys_TSQL"
- "sys.asymmetric_keys" dev_langs:
- "TSQL" helpviewer_keywords:
- "sys.asymmetric_keys catalog view" ms.assetid: bbca796a-9bb5-4a62-9ca8-1d255984553d caps.latest.revision: 35 author: "edmacauley" ms.author: "edmaca" manager: "craigg" ms.workload: "Inactive" monikerRange: "= azuresqldb-current || >= sql-server-2016 || = sqlallproducts-allversions"
[!INCLUDEtsql-appliesto-ss2008-asdb-xxxx-xxx-md]
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. |
[!INCLUDEssCatViewPerm] For more information, see Metadata Visibility Configuration.
Security Catalog Views (Transact-SQL)
Extensible Key Management (EKM)
Catalog Views (Transact-SQL)
Encryption Hierarchy
CREATE ASYMMETRIC KEY (Transact-SQL)