Listing Asymmetric and Symmetric Keys in a SQL Server 2005 Database

If you ever want to see a list of keys in your current database or see some of their properties (e.g. the encryption alogorithm used), just use the two statements below to list your symmetric and asymmetric keys from the system catalog views: SELECT * FROM sys.symmetric_keys; SELECT * FROM sys.asymmetric_keys;