USE AdventureWorks2016
select * from sys.asymmetric_keys

-- Create Asymmetric Keys named "TESTINGAK01"
-- which is protected by DMK and RSA algorithm with 2048
USE AdventureWorks2016
CREATE ASYMMETRIC KEY TESTINGAK01
WITH ALGORITHM = RSA_2048

-- Create Asymmetric Keys named "TESTINGAK02"
-- which is protected by Password and RSA algorithm with 2048
USE AdventureWorks2016
CREATE ASYMMETRIC KEY TESTINGAK02
WITH ALGORITHM = RSA_2048
ENCRYPTION BY PASSWORD = 'P@ssw0rd'

-- Drop Asymmetric keys named "TESTINGAK01"
USE AdventureWorks2016
DROP ASYMMETRIC KEY TESTINGAK01

USE AdventureWorks2016
ALTER ASYMMETRIC KEY TESTINGAK02
WITH PRIVATE KEY (
DECRYPTION BY PASSWORD = 'P@ssw0rd',
ENCRYPTION BY PASSWORD = 'newP@ssw0rd'
)

USE AdventureWorks2016
ALTER ASYMMETRIC KEY TESTINGAK02
WITH PRIVATE KEY (
ENCRYPTION BY PASSWORD = 'P@ssw0rd'
)

USE AdventureWorks2016
ALTER ASYMMETRIC KEY TESTINGAK02
WITH PRIVATE KEY (
DECRYPTION BY PASSWORD = 'P@ssw0rd'
)