I have a user defined table type in SQL Server 2014 that I need to drop and recreate. However, if I use the script from SSMS, the default value constraints that are on some of the columns, will not be created.
I also have problems viewing the default constraint, so I do not what the default value should be.
Is there a way to view what those default value constraints contain?
CREATE TYPE [Logging].[LogElements] AS TABLE( [LogMessage] [nvarchar](MAX) NOT NULL, [MessageTypeId] [smallint] NOT NULL, [Origin] [varchar](50) NOT NULL, [JobRunId] [int] NULL, [InvoiceId] [int] NULL, [AccountlineId] [int] NULL, [MSErrorCode] [bigint] NOT NULL, [LogStatusId] [int] NOT NULL, [LogUser] [varchar](50) NULL
Above is the definition as it is created when generating script in SSMS. As you can see, the default values are not in the script.