Masking entire table in one line of script - DDM

Question

Hi all,is there a way in Dynamic Data Masking (DDM) to mask an entire table 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 = &nbsp;'default()')

olafhelper · Answer

As for every ALTER TABLE command, you can address 1-n columns; so yes, it's possible.

marcin rachwalski · Answer

olafhelper&nbsp;What would be the t-sql query ? Example table name:&nbsp;[Main].[SampleTable]

mihaid · Answer

no

olafhelper · Answer

For the ALTER TABLE syntax seehttps://learn.microsoft.com/en-us/sql/t-sql/statements/alter-table-transact-sql?view=sql-server-ver16

Forum Discussion

Masking entire table in one line of script - DDM

4 Replies

Resources