Dynamic Data Masking - limitation external tables
In an external table, data masking appears to be unsupported.
ALTER TABLE XXXX
ALTER COLUMN Name ADD MASKED WITH (FUNCTION = 'default()');
The feature 'ALTER TABLE' is not supported with external tables.
- It would be great if it were supported.
- note this as a (current) limitation in the documentation https://docs.microsoft.com/en-us/sql/relational-databases/security/dynamic-data-masking?view=sql-server-ver15#limitations-and-restrictions