Steve Jones shows how to drop Dynamic Data Masking from a column:
This is a quick one. As I experimented with Dynamic Data Masking for the Stairway to Dynamic Data Masking, and writing my Using SQL Compare with Dynamic Data Masking, I needed to remove masking from a column. I didn’t want to rebuild tables, and hoped there was an easy way to ALTER a column.
There is.
The more I’ve seen of DDM, the less I like it. So I’m more a fan of scripts to remove it than scripts to add it…