

if exists(SELECT 1 FROM INFORMATION_SCHEMA.TABLE_CONSTRAINTS WHERE CONSTRAINT_NAME='FK_Role_Group_Roles')
	ALTER TABLE [dbo].[Role_Group] DROP CONSTRAINT [FK_Role_Group_Roles]

if exists(SELECT 1 FROM INFORMATION_SCHEMA.TABLE_CONSTRAINTS WHERE CONSTRAINT_NAME='FK_Roles_NotificationProfile')
	ALTER TABLE [dbo].[Roles] DROP CONSTRAINT [FK_Roles_NotificationProfile]

if exists(SELECT 1 FROM INFORMATION_SCHEMA.TABLE_CONSTRAINTS WHERE CONSTRAINT_NAME='FK_CD_Panel_Common_Label_CD_Language')
	ALTER TABLE [dbo].[CD_Panel_Common_Label] DROP CONSTRAINT [FK_CD_Panel_Common_Label_CD_Language]

if exists(SELECT 1 FROM INFORMATION_SCHEMA.TABLE_CONSTRAINTS WHERE CONSTRAINT_NAME='FK_LanguageCode')
	ALTER TABLE [dbo].[CD_NotificationMessages] DROP CONSTRAINT [FK_LanguageCode]
	
if exists(SELECT 1 FROM INFORMATION_SCHEMA.TABLE_CONSTRAINTS WHERE CONSTRAINT_NAME='FK_NotificationFormats_LanguageCode')
	ALTER TABLE [dbo].[CD_NotificationFormats] DROP CONSTRAINT [FK_NotificationFormats_LanguageCode]

if exists(SELECT 1 FROM INFORMATION_SCHEMA.TABLE_CONSTRAINTS WHERE CONSTRAINT_NAME='FK_CD_Device_Type_Codes_CD_Language_Codes')
	ALTER TABLE [dbo].[CD_Device_Type] DROP CONSTRAINT [FK_CD_Device_Type_Codes_CD_Language_Codes]

if exists(SELECT 1 FROM INFORMATION_SCHEMA.TABLE_CONSTRAINTS WHERE CONSTRAINT_NAME='FK_CD_Communication_Channel_CD_Language')
	ALTER TABLE [dbo].[CD_Communication_Channel] DROP CONSTRAINT [FK_CD_Communication_Channel_CD_Language]

if exists(SELECT 1 FROM INFORMATION_SCHEMA.TABLE_CONSTRAINTS WHERE CONSTRAINT_NAME='FK_CD_Panel_Status_CD_Language_Codes')
	ALTER TABLE [dbo].[CD_Panel_Status] DROP CONSTRAINT [FK_CD_Panel_Status_CD_Language_Codes]

if exists(SELECT 1 FROM INFORMATION_SCHEMA.TABLE_CONSTRAINTS WHERE CONSTRAINT_NAME='FK_CD_Panel_Type_CD_Language_Codes')
	ALTER TABLE [dbo].[CD_Panel_Type] DROP CONSTRAINT [FK_CD_Panel_Type_CD_Language_Codes]
