Data Mask SQL

 
 

Substitute.GUID

Sample SQL...

/*===================================================================================
 Mask Type: Substitute.GUID =====================================================================================*/
/*---------------------------------------------------------------------
Table: [dbo].[DatabaseLog]
Column: [Object]
Mask:
* Type: 'Substitute: GUID'
* Category: 'Substitute' - overwrite all rows with a "random" value
* Descrip: This mask overwrites all rows with a random 36 character GUID string.
           These strings are unique across time and space.
---------------------------------------------------------------------*/

UPDATE [dbo].[DatabaseLog]
SET [Object] = NEWID()  
 

eXTReMe Tracker