SQL Server: asymmetric keys

Mapped logins

create login … from asymmetric key …;

select
   p.name      login_name,
   p.type_desc           ,  -- ASYMMETRIC_KEY_MAPPED_LOGIN
   a.name      key_name  ,
   a.algorithm_desc      ,
   a.key_length
from
   sys.asymmetric_keys   a                   join
   sys.server_principals p on a.sid = p.sid