title: "sys.crypt_properties (Transact-SQL) | Microsoft Docs" ms.custom: "" ms.date: "03/14/2017" ms.prod: sql ms.prod_service: "database-engine, sql-database" ms.component: "system-catalog-views" ms.reviewer: "" ms.suite: "sql" ms.technology: system-objects ms.tgt_pltfrm: "" ms.topic: "language-reference" f1_keywords:
- "crypt_properties"
- "crypt_properties_TSQL"
- "sys.crypt_properties_TSQL"
- "sys.crypt_properties" dev_langs:
- "TSQL" helpviewer_keywords:
- "sys.crypt_properties catalog view" ms.assetid: d5684f5a-30b1-418e-ae4d-ab040db9257e caps.latest.revision: 29 author: edmacauley ms.author: edmaca manager: craigg monikerRange: "=azuresqldb-current||>=sql-server-2016||=sqlallproducts-allversions||>=sql-server-linux-2017"
[!INCLUDEtsql-appliesto-ss2008-asdb-xxxx-xxx-md]
Returns one row for each cryptographic property associated with a securable.
| Column name | Data type | Description |
|---|---|---|
| class | tinyint | Identifies class of thing on which property exists. 1 = Object or column 5 = Assembly |
| class_desc | nvarchar(60) | Description of the class of thing on which property exists. OBJECT_OR_COLUMN ASSEMBLY |
| major_id | int | ID of thing on which property exists, interpreted according to class |
| thumbprint | varbinary(32) | SHA-1 hash of the certificate or asymmetric key used. |
| crypt_type | char(4) | Encryption type. SPVC = Encrypted by certificate private key SPVA = Encrypted by asymmetric private key CPVC = Counter signature by certificate private key CPVA = Counter signature by asymmetric key |
| crypt_type_desc | nvarchar(60) | Description of encryption type. SIGNATURE BY CERTIFICATE SIGNATURE BY ASYMMETRIC KEY COUNTER SIGNATURE BY CERTIFICATE COUNTER SIGNATURE BY ASYMMETRIC KEY |
| crypt_property | varbinary(max) | Signed or encrypted bits. |
[!INCLUDEssCatViewPerm] For more information, see Metadata Visibility Configuration.
Security Catalog Views (Transact-SQL)
Encryption Hierarchy
Securables
CREATE CERTIFICATE (Transact-SQL)
CREATE SYMMETRIC KEY (Transact-SQL)
CREATE ASYMMETRIC KEY (Transact-SQL)
Catalog Views (Transact-SQL)