Export (0) Print
Expand All
This topic has not yet been rated - Rate this topic

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.

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.

Did you find this helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

ADD
Show:
© 2014 Microsoft. All rights reserved.