Skip to content

Instantly share code, notes, and snippets.

@samirbehara-zz

samirbehara-zz/Modifying mask column using Dynamic Data Masking

Created October 28, 2017 11:41
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/cd417272998637fc5200e7a92a66325e to your computer and use it in GitHub Desktop.
Save samirbehara-zz/cd417272998637fc5200e7a92a66325e to your computer and use it in GitHub Desktop.
Download ZIP
Raw
Modifying mask column using Dynamic Data Masking
-- Modify your existing masked columns
ALTER TABLE dbo.Customer
ALTER COLUMN LastName ADD MASKED WITH (FUNCTION = 'partial(2,"X-XXX-X",1)')
-- View the unmasked data in Customer table
SELECT * FROM dbo.Customer;
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment