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.
|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.|
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.|
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.
Security Catalog Views (Transact-SQL)
CREATE CERTIFICATE (Transact-SQL)
CREATE SYMMETRIC KEY (Transact-SQL)
CREATE ASYMMETRIC KEY (Transact-SQL)
Catalog Views (Transact-SQL)