For a table which has dynamic data masking enabled if I try generating (create table) scripts from SSMS (13.0.1711.0) it is not scripting the MASKED function details. Is there any other way to do it?
CREATE TABLE TestTable ( Sno INT IDENTITY(1, 1) PRIMARY KEY ,FirstName VARCHAR(50) NOT NULL ) GO ALTER TABLE TestTable ALTER COLUMN FirstName varchar(50) MASKED WITH (FUNCTION = 'default()'); GO
Currently this is the output I get via SSMS - Generate Scripts
CREATE TABLE [dbo].[TestTable]( [Sno] [int] IDENTITY(1,1) NOT NULL, [FirstName] [varchar](50) NULL, PRIMARY KEY CLUSTERED ( [Sno] ASC )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY] ) ON [PRIMARY] GO
Applied CU2 for Microsoft SQL Server 2016 RTM (KB3182270) and now SQL Server 2016 build number is 13.0.2164.0
SSMS Versions is shown as 13.0.15900.1 (Even have tried downloading the SSMS once again as suggested by Aaron Bertrand and reinstalling it)
Still the original problem is not resolved - Scripting the table gives the same result as original posted.