USE [Astria_Host] GO ALTER TABLE dbo.License NOCHECK CONSTRAINT ALL GO ALTER TABLE dbo.LicenseSeat NOCHECK CONSTRAINT ALL GO ALTER TABLE dbo.Licenseusage NOCHECK CONSTRAINT ALL ALTER TABLE [dbo].[CompanyInstance] DROP CONSTRAINT [FK_CompanyInstance_Company] GO ALTER TABLE [dbo].[License] DROP CONSTRAINT [FK_License_Company] ALTER TABLE [dbo].[Licenseusage] DROP CONSTRAINT [FK_LicenseUsage_License] GO update dbo.Company set ProvisioningCode = NULL where id = (select companyid from dbo.CompanyInstance where name = 'AAAA0001') GO update dbo.Company set Key1 = '00000000-0000-0000-0000-000000000000', Key2 = '00000000-0000-0000-0000-000000000000', Key3 = '00000000-0000-0000-0000-000000000000' where ProvisioningCode is NULL GO update dbo.CompanyInstance set CompanyId = NEWID() where name = 'AAAA0001' GO update dbo.Company set id = (select companyid from dbo.CompanyInstance where name = 'AAAA0001') GO delete from dbo.License GO ALTER TABLE [dbo].[CompanyInstance] WITH CHECK ADD CONSTRAINT [FK_CompanyInstance_Company] FOREIGN KEY([CompanyId]) REFERENCES [dbo].[Company] ([Id]) ON DELETE CASCADE GO ALTER TABLE [dbo].[CompanyInstance] CHECK CONSTRAINT [FK_CompanyInstance_Company] GO ALTER TABLE [dbo].[License] WITH CHECK ADD CONSTRAINT [FK_License_Company] FOREIGN KEY([CompanyId]) REFERENCES [dbo].[Company] ([Id]) ON DELETE CASCADE GO delete from dbo.LicenseUsage GO ALTER TABLE [dbo].[LicenseUsage] WITH CHECK ADD CONSTRAINT [FK_LicenseUsage_License] FOREIGN KEY([LicenseId]) REFERENCES [dbo].[License] ([Id]) GO ALTER TABLE [dbo].[LicenseUsage] CHECK CONSTRAINT [FK_LicenseUsage_License] GO ALTER TABLE [dbo].[License] CHECK CONSTRAINT [FK_License_Company] GO ALTER TABLE dbo.License CHECK CONSTRAINT ALL GO ALTER TABLE dbo.LicenseSeat CHECK CONSTRAINT ALL GO