Is there a quick way to find all columns in SQL Server 2008 R2 that are encrypted/have encrypted data?

Is there a quick way to find all columns in SQL Server 2008 R2 that are encrypted/have encrypted data?

 

SELECT t.name AS [Table],
       c.name AS [Column],
       c.encryption_type_desc
FROM sys.all_columns c
    INNER JOIN sys.tables t
        ON c.object_id = t.object_id
WHERE c.encryption_type IS NOT NULL
ORDER BY t.name,
         c.name;

 

posted @ 2022-09-07 14:29  ChuckLu  阅读(21)  评论(0)    收藏  举报