sys.crypt_properties (Transact-SQL)

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
class_desc	nvarchar(60)	Description of the class of thing on which property exists. OBJECT_OR_COLUMN
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.

See Also