Online Documentation for SQL Manager for SQL server
Creating/editing symmetric key
Use the Symmetric key tab of Symmetric Key Editor to create/edit a symmetric key and specify its properties.
Enter a name for the new symmetric key, or view the name of the symmetric key being edited.
Specify a passphrase that will be used to derive the key from.
Use the drop-down list to specify an algorithm to be used by the symmetric key. Possible values are: DES, TRIPLE_DES, RC2, RC4, DESX, AES_128, AES_192, AES_256.
Specify an identity phrase from which to generate a GUID for tagging data that is encrypted with a temporary key.
Stores the date when the symmetric key was created.
Stores the date when the symmetric key was last modified.
Symmetric key encrypt by
This area lists the encrypting mechanisms used by the symmetric key (the ENCRYPTION BY clause).
To add an encrypting mechanism, right-click within the Symmetric key encrypt by area and select the Add Encryption popup menu item.
To remove an encrypting mechanism, right-click the encrypting mechanism within the Symmetric key encrypt by area and select the Drop Encryption popup menu item.