sys.crypt_properties (Transact-SQL)
Applies to: 
SQL Server
Azure SQL Database
Azure SQL Managed Instance
SQL database in Microsoft Fabric
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
The visibility of the metadata in catalog views is limited to securables that a user either owns, or on which the user was granted some permission. 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)