ALTER TABLE [ASM_IVNT_DeviceDesiredState] DROP CONSTRAINT FK_ASM_IVNT_DeviceDesiredState_Device_Cascade_Delete
GO
ALTER TABLE [ASM_IVNT_DeviceDesiredState] ADD CONSTRAINT [FK_ASM_IVNT_DeviceDesiredState_Device] FOREIGN KEY ([DeviceID]) REFERENCES [Device]([DeviceID]) ON DELETE CASCADE ON UPDATE CASCADE
GO