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

Topic Status: Some information in this topic is preview and subject to change in future releases. Preview information describes new features or changes to existing features in Microsoft SQL Server 2016 Community Technology Preview 2 (CTP2).

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