sys.dm_cryptographic_provider_algorithms (Transact-SQL)
Applies to:
SQL Server
Returns the algorithms supported by an Extensible Key Management (EKM) provider.
Transact-SQL syntax conventions (Transact-SQL)
Syntax
sys.dm_cryptographic_provider_algorithms ( provider_id )
Arguments
provider_id
Identification number of the EKM provider, with no default.
Tables Returned
Column name | Data type | Description |
---|---|---|
algorithm_id | int | Is the identification number of the algorithm. |
algorithm_tag | nvarchar(60) | Is the identification tag of the algorithm. |
key_type | nvarchar(128) | Shows the key type. Returns either ASYMMETRIC KEY or SYMMETRIC KEY. |
key_length | int | Indicates the key length in bits. |
Permissions
The user must be a member of the public database role.
Examples
The following example shows the provider options for a provider with the identification number of 1234567
.
SELECT * FROM sys.dm_cryptographic_provider_algorithms(1234567);
GO
See Also
Extensible Key Management (EKM)
Security-Related Dynamic Management Views and Functions (Transact-SQL)
Feedback
https://aka.ms/ContentUserFeedback.
În curând: Pe parcursul anului 2024, vom elimina treptat Probleme legate de GitHub ca mecanism de feedback pentru conținut și îl vom înlocui cu un nou sistem de feedback. Pentru mai multe informații, consultați:Trimiteți și vizualizați feedback pentru