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. |
In SQL Server 2005 and later versions, the visibility of the metadata in catalog views is limited to securables that a user either owns or on which the user has been granted some permission. For more information, see Metadata Visibility Configuration.
