Get encrypted column name with their encryption key and certificate in sql server
After search and try I found the solution that is -
SELECT DISTINCT key_name(encryptedcol) FROM encryptedTable;
This query gives result the encrypted key which is belong to that column.
I am using SQL Server 2016 .
Below here is the query to get all required Encrypted columns with key.
SELECT t.name AS TableName
,c.name AS ColumnName
,c.max_length
,k.name AS KeyName
,c.encryption_type_desc
,c.encryption_algorithm_name
FROM sys.columns c
INNER JOIN sys.column_encryption_keys k ON c.column_encryption_key_id = k.column_encryption_key_id
INNER JOIN sys.tables t ON c.object_id = t.object_id
WHERE encryption_type IS NOT NULL