USP_GETENCRYPTEDFIELDS

                create procedure dbo.USP_GETENCRYPTEDFIELDS
                as
                    select TABLENAME, ENCRYPTEDCOLUMNS.*
                    from dbo.TABLECATALOG as T
                    cross apply dbo.UFN_TABLESPEC_GETENCRYPTEDFIELDS(T.TABLESPECXML) as ENCRYPTEDCOLUMNS

                    union all 

                    select TABLENAME + 'AUDIT', ENCRYPTEDCOLUMNS.*
                    from dbo.TABLECATALOG as T
                    cross apply dbo.UFN_TABLESPEC_GETENCRYPTEDFIELDS(T.TABLESPECXML) as ENCRYPTEDCOLUMNS
                    where exists(SELECT TABLE_NAME FROM INFORMATION_SCHEMA.TABLES WHERE (TABLE_SCHEMA = 'dbo') AND (TABLE_NAME = (T.TABLENAME + 'AUDIT')))

                    order by 1, 2