Skip to content

Instantly share code, notes, and snippets.

@samirbehara-zz

samirbehara-zz/Track all masked columns in database

Created October 22, 2017 21:03
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save samirbehara-zz/c964160cd92774a8830617263f194ca2 to your computer and use it in GitHub Desktop.
Save samirbehara-zz/c964160cd92774a8830617263f194ca2 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
Track all masked columns in database
-- View the columns where the Masking function is applied
SELECT c.name 'ColumnName', tbl.name 'TableName',
c.is_masked 'IsMasked', c.masking_function 'MaskingFunction'
FROM sys.masked_columns AS c
JOIN sys.tables AS tbl
ON c.[object_id] = tbl.[object_id]
WHERE is_masked = 1;
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment