Data Mask SQL



Sample SQL...

 Mask Type: Scrub.FixedString
Table: [dbo].[DatabaseLog] Column: [Event] Mask:
* Type: 'Scrub: Fixed String...'
* Params: 'Event'
* Category: 'Scrub' - overwrite all rows with "same" value
* Descrip: This mask overwrites all rows with a fixed string in this column; where
  fixed string is text you enter Note that the text value is truncated by the width
  of the column's data length (prevent user from entering too large of a string
  that would error the tSQL)

UPDATE [dbo].[DatabaseLog]
SET [Event] = LEFT('Event', 128)

eXTReMe Tracker