sys-crypt-properties-transact-sql.md

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.reviewer
ms.technology	system-objects
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
author	VanMSFT
ms.author	vanto
monikerRange	=azuresqldb-current||>=sql-server-2016||=sqlallproducts-allversions||>=sql-server-linux-2017||=azuresqldb-mi-current

sys.crypt_properties (Transact-SQL)

[!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 = Signed by certificate private key SPVA = Signed 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. For a signed module these are the signature bits of the module.

Permissions

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

See Also

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)