-- Create Asymmetric Keys named "TESTINGSK01"
-- which is protected by Certificate named "TESTINGC01"
-- and AES algorithm with 256
CREATE SYMMETRIC KEY TESTINGSK01
WITH ALGORITHM = AES_256
ENCRYPTION BY CERTIFICATE TESTINGC01

-- Create Asymmetric Keys named "TESTINGSK02"
-- which is protected by Password "P@ssw0rd"
-- and AES algorithm with 256
CREATE SYMMETRIC KEY TESTINGSK02
WITH ALGORITHM = AES_256
ENCRYPTION BY PASSWORD = 'P@ssw0rd'

-- Create Asymmetric Keys named "TESTINGSK03"
-- which is protected by Asymmetric Key named "TESTINGAK01"
-- and AES algorithm with 256
CREATE SYMMETRIC KEY TESTINGSK03
WITH ALGORITHM = AES_256
ENCRYPTION BY ASYMMETRIC KEY TESTINGAK01

-- You need open the Symmetric Key first
OPEN SYMMETRIC KEY TESTINGSK02 DECRYPTION BY PASSWORD = 'P@ssw0rd'
-- Create Asymmetric Keys named "TESTINGSK03"
-- which is protected by Symmetric Key named "TESTINGAK02"
-- and AES algorithm with 256.
CREATE SYMMETRIC KEY TESTINGSK03
WITH ALGORITHM = AES_256
ENCRYPTION BY SYMMETRIC KEY TESTINGSK02
-- Close the opened key
CLOSE SYMMETRIC KEY TESTINGSK02

DROP SYMMETRIC KEY TESTINGSK04

-- You need to open the Symmetric Key first
OPEN SYMMETRIC KEY TESTINGSK03 DECRYPTION BY ASYMMETRIC KEY TESTINGAK01
-- Change encryption method from Asymmetric key to password
ALTER SYMMETRIC KEY TESTINGSK03 ADD ENCRYPTION BY PASSWORD = 'P@ssw0rd'
ALTER SYMMETRIC KEY TESTINGSK03 DROP ENCRYPTION BY ASYMMETRIC KEY TESTINGAK01
-- Close the opened key
CLOSE SYMMETRIC KEY TESTINGSK03