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. |
Permissions
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.