Ali je bila ta stran uporabna?
Vaše povratne informacije o tej vsebini so pomembne. Sporočite nam svoje mnenje.
Dodatne povratne informacije?
Preostali znaki: 1500
Izvozi (0) Natisni
Razširi vse
EN
Ta vsebina ni na voljo v vašem jeziku, vendar pa je tukaj angleška različica.

sys.dm_cryptographic_provider_algorithms (Transact-SQL)

 

Applies To: SQL Server 2014, SQL Server 2016 Preview

Returns the algorithms supported by an Extensible Key Management (EKM) provider.

Applies to: SQL Server (SQL Server 2008 through current version).

Topic link icon Transact-SQL Syntax Conventions

sys.dm_cryptographic_provider_algorithms ( provider_id )

provider_id

Identification number of the EKM provider, with no default.

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.

The user must be a member of the public database role.

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

Vsebina skupnosti

Dodaj
Pokaži:
© 2015 Microsoft