Chapter 2: Encrypted Columns
sp_dropuser
sp_dropuser
drops all key copies from
sysencryptkeys
for the specified user in the current database.