| title | description | author | ms.author | ms.date | ms.service | ms.subservice | ms.topic | ms.custom | f1_keywords | helpviewer_keywords | dev_langs | monikerRange | |||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
sys.crypt_properties (Transact-SQL) |
sys.crypt_properties (Transact-SQL) |
VanMSFT |
vanto |
03/14/2017 |
sql |
system-objects |
reference |
|
|
|
|
=azuresqldb-current || >=sql-server-2016 || >=sql-server-linux-2017 || =azuresqldb-mi-current || =fabric |
[!INCLUDE SQL Server Azure SQL Database Azure SQL Managed Instance FabricSQLDB]
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. OBJECT_OR_COLUMN ASSEMBLY |
| 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 = Signed by certificate private key SPVA = Signed 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. For a signed module these are the signature bits of the module. |
[!INCLUDEssCatViewPerm] For more information, see Metadata Visibility Configuration.
Security Catalog Views (Transact-SQL)
Encryption Hierarchy
Securables
CREATE CERTIFICATE (Transact-SQL)
CREATE SYMMETRIC KEY (Transact-SQL)
CREATE ASYMMETRIC KEY (Transact-SQL)
Catalog Views (Transact-SQL)