
--Migration_RCCP_20240821_163702.txt
ALTER TABLE [dbo].[EntityLicences] ADD [EntityId] [nvarchar](max)
ALTER TABLE [dbo].[EntityLicenceLinks] ADD [LicenceType] [nvarchar](max)
ALTER TABLE [dbo].[EntityLicenceLinks] ADD [StartDateTime] [datetime] NOT NULL DEFAULT '1900-01-01T00:00:00.000'
ALTER TABLE [dbo].[EntityLicenceLinks] ADD [ExpiryDateTime] [datetime] NOT NULL DEFAULT '1900-01-01T00:00:00.000'
DECLARE @var0 nvarchar(128)
SELECT @var0 = name
FROM sys.default_constraints
WHERE parent_object_id = object_id(N'dbo.EntityLicences')
AND col_name(parent_object_id, parent_column_id) = 'Credit';
IF @var0 IS NOT NULL
    EXECUTE('ALTER TABLE [dbo].[EntityLicences] DROP CONSTRAINT [' + @var0 + ']')
ALTER TABLE [dbo].[EntityLicences] DROP COLUMN [Credit]
