Symmetric Key Editor (SQL Server)

From DBArtisan
Jump to: navigation, search

Go Up to Microsoft SQL Server Object Editors

The Symmetric Key Editor lets you view creation details for a key and modify its encryption mechanisms.

To edit a symmetric key:

  1. Open an editor on the symmetric key. For details, see Opening an Object Editor.
  2. Use the following table as a guide to understanding and modifying the settings on the tabs of this editor:
Tab Settings and tasks


Lets you view the Authorization Owner, Name, Create Date, Update Date, Provider Name, Key Algorithm, and Key Length properties. For more information, see Symmetric Keys (SQL Server) - Properties.

Encryption Mechanisms

Lets you manage the encryption mechanisms for this key. For detailed instructions, see Symmetric Keys (SQL Server) - Properties.

DDL View

For details on using this tab, see Viewing the SQL/DDL for an Object.

3. When finished, you can submit your changes. For details, see Previewing and Submitting Object Editor Changes.