is there a way in Microsoft Dynamic Data Masking (DDM) to mask an entire table in sql server with just one line of script using the same function for all columns? defining the masking rule on the table as a whole?
something like: ALTER TableName ADD MASKED WITH (FUNCTION = 'default()')
I am trying to mask an entire table in an SQL server database using dynamic data masking and would like to find a fast and easy way to do it in one line of script, since I need all the columns masked and I need them to be masked with the same function, "DEFAULT".
