.png)
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. |
