Note
Access to this page requires authorization. You can try signing in or changing directories.
Access to this page requires authorization. You can try changing directories.
Returns one row for every symmetric key created with the CREATE SYMMETRIC KEY statement.
| Column name | Data type | Description |
|---|---|---|
name |
sysname |
Name of the key. Unique within the database. |
principal_id |
int |
ID of the database principal who owns the key. |
symmetric_key_id |
int |
ID of the key. Unique within the database. |
key_length |
int |
Length of the key in bits. |
key_algorithm |
char(2) |
Algorithm used with the key: R2 = RC2 R4 = RC4 D = DES D3 = Triple DES DX = DESX A1 = AES 128 A2 = AES 192 A3 = AES 256 |
algorithm_desc |
nvarchar(60) |
Description of the algorithm used with the key: RC2 RC4 DES Triple_DES DESX AES_128 AES_192 AES_256 |
create_date |
datetime |
Date the key was created. |
modify_date |
datetime |
Date the key was modified. |
key_guid |
uniqueidentifier |
Globally unique identifier (GUID) associated with the key. It is auto-generated for persisted keys. GUIDs for temporary keys are derived from the user-supplied pass phrase. |
Clarification regarding DES algorithms:
- DESX was incorrectly named. Symmetric keys created with ALGORITHM = DESX actually use the TRIPLE DES cipher with a 192-bit key. The DESX algorithm is not provided.
- Symmetric keys created with ALGORITHM = TRIPLE_DES use TRIPLE DES with a 128-bit key.
See Also
Reference
Catalog Views (Transact-SQL)
Security Catalog Views (Transact-SQL)
CREATE SYMMETRIC KEY (Transact-SQL)
Other Resources
Help and Information
Getting SQL Server 2005 Assistance
Change History
| Release | History |
|---|---|
17 November 2008 |
|