Forum Discussion
Masking entire table in one line of script - DDM
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? ...
As for every ALTER TABLE command, you can address 1-n columns; so yes, it's possible.
olafhelper What would be the t-sql query ? Example table name: [Main].[SampleTable]
- For the ALTER TABLE syntax see
https://learn.microsoft.com/en-us/sql/t-sql/statements/alter-table-transact-sql?view=sql-server-ver16
