PRINT N'Dropping unnamed constraint on [dbo].[T_APPOINTMENT]...';


GO
ALTER TABLE [dbo].[T_APPOINTMENT] DROP CONSTRAINT IF EXISTS [DF__T_APPOINT__CREAT__0876219E];


GO
PRINT N'Dropping unnamed constraint on [dbo].[T_APPOINTMENT]...';


GO
ALTER TABLE [dbo].[T_APPOINTMENT] DROP CONSTRAINT IF EXISTS [DF__T_APPOINT__LASTC__0781FD65];


GO
PRINT N'Dropping unnamed constraint on [dbo].[T_APPOINTMENT]...';


GO
ALTER TABLE [dbo].[T_APPOINTMENT] DROP CONSTRAINT IF EXISTS [DF__T_APPOINT__TOROL__0599B4F3];


GO
PRINT N'Dropping unnamed constraint on [dbo].[T_APPOINTMENT]...';


GO
ALTER TABLE [dbo].[T_APPOINTMENT] DROP CONSTRAINT IF EXISTS [DF__T_APPOINT__SERIA__068DD92C];


GO
PRINT N'Dropping unnamed constraint on [dbo].[T_AUTOMATICMESSAGES]...';


GO
ALTER TABLE [dbo].[T_AUTOMATICMESSAGES] DROP CONSTRAINT IF EXISTS [DF__T_AUTOMAT__C_KED__70D3A237];


GO
PRINT N'Dropping unnamed constraint on [dbo].[T_AUTOMATICMESSAGES]...';


GO
ALTER TABLE [dbo].[T_AUTOMATICMESSAGES] DROP CONSTRAINT IF EXISTS [DF__T_AUTOMAT__C_PEN__71C7C670];


GO
PRINT N'Dropping unnamed constraint on [dbo].[T_AUTOMATICMESSAGES]...';


GO
ALTER TABLE [dbo].[T_AUTOMATICMESSAGES] DROP CONSTRAINT IF EXISTS [DF__T_AUTOMAT__SERIA__77809FC6];


GO
PRINT N'Dropping unnamed constraint on [dbo].[T_AUTOMATICMESSAGES]...';


GO
ALTER TABLE [dbo].[T_AUTOMATICMESSAGES] DROP CONSTRAINT IF EXISTS [DF__T_AUTOMAT__CREAT__7968E838];


GO
PRINT N'Dropping unnamed constraint on [dbo].[T_AUTOMATICMESSAGES]...';


GO
ALTER TABLE [dbo].[T_AUTOMATICMESSAGES] DROP CONSTRAINT IF EXISTS [DF__T_AUTOMAT__C_CSU__6EEB59C5];


GO
PRINT N'Dropping unnamed constraint on [dbo].[T_AUTOMATICMESSAGES]...';


GO
ALTER TABLE [dbo].[T_AUTOMATICMESSAGES] DROP CONSTRAINT IF EXISTS [DF__T_AUTOMAT__C_VAN__75985754];


GO
PRINT N'Dropping unnamed constraint on [dbo].[T_AUTOMATICMESSAGES]...';


GO
ALTER TABLE [dbo].[T_AUTOMATICMESSAGES] DROP CONSTRAINT IF EXISTS [DF__T_AUTOMAT__C_SZO__73B00EE2];


GO
PRINT N'Dropping unnamed constraint on [dbo].[T_AUTOMATICMESSAGES]...';


GO
ALTER TABLE [dbo].[T_AUTOMATICMESSAGES] DROP CONSTRAINT IF EXISTS [DF__T_AUTOMAT__C_HET__6FDF7DFE];


GO
PRINT N'Dropping unnamed constraint on [dbo].[T_AUTOMATICMESSAGES]...';


GO
ALTER TABLE [dbo].[T_AUTOMATICMESSAGES] DROP CONSTRAINT IF EXISTS [DF__T_AUTOMAT__LASTC__7874C3FF];


GO
PRINT N'Dropping unnamed constraint on [dbo].[T_AUTOMATICMESSAGES]...';


GO
ALTER TABLE [dbo].[T_AUTOMATICMESSAGES] DROP CONSTRAINT IF EXISTS [DF__T_AUTOMAT__C_VAS__74A4331B];


GO
PRINT N'Dropping unnamed constraint on [dbo].[T_AUTOMATICMESSAGES]...';


GO
ALTER TABLE [dbo].[T_AUTOMATICMESSAGES] DROP CONSTRAINT IF EXISTS [DF__T_AUTOMAT__C_SZE__72BBEAA9];


GO
PRINT N'Dropping unnamed constraint on [dbo].[T_AUTOMATICMESSAGES]...';


GO
ALTER TABLE [dbo].[T_AUTOMATICMESSAGES] DROP CONSTRAINT IF EXISTS [DF__T_AUTOMAT__TOROL__768C7B8D];


GO
PRINT N'Dropping unnamed constraint on [dbo].[T_DIGESTEMAILMESSAGE]...';


GO
ALTER TABLE [dbo].[T_DIGESTEMAILMESSAGE] DROP CONSTRAINT IF EXISTS [DF__T_DIGESTE__TOROL__01FE2E39];


GO
PRINT N'Dropping unnamed constraint on [dbo].[T_DIGESTEMAILMESSAGE]...';


GO
ALTER TABLE [dbo].[T_DIGESTEMAILMESSAGE] DROP CONSTRAINT IF EXISTS [DF__T_DIGESTE__SERIA__02F25272];


GO
PRINT N'Dropping unnamed constraint on [dbo].[T_DIGESTEMAILMESSAGE]...';


GO
ALTER TABLE [dbo].[T_DIGESTEMAILMESSAGE] DROP CONSTRAINT IF EXISTS [DF__T_DIGESTE__LASTC__03E676AB];


GO
PRINT N'Dropping unnamed constraint on [dbo].[T_DIGESTEMAILMESSAGE]...';


GO
ALTER TABLE [dbo].[T_DIGESTEMAILMESSAGE] DROP CONSTRAINT IF EXISTS [DF__T_DIGESTE__CREAT__04DA9AE4];


GO
PRINT N'Dropping unnamed constraint on [dbo].[T_DIGESTMESSAGEQUEUE]...';


GO
ALTER TABLE [dbo].[T_DIGESTMESSAGEQUEUE] DROP CONSTRAINT IF EXISTS [DF__T_DIGESTM__CREAT__104C4D90];


GO
PRINT N'Dropping unnamed constraint on [dbo].[T_DIGESTMESSAGEQUEUE]...';


GO
ALTER TABLE [dbo].[T_DIGESTMESSAGEQUEUE] DROP CONSTRAINT IF EXISTS [DF__T_DIGESTM__TOROL__0D6FE0E5];


GO
PRINT N'Dropping unnamed constraint on [dbo].[T_DIGESTMESSAGEQUEUE]...';


GO
ALTER TABLE [dbo].[T_DIGESTMESSAGEQUEUE] DROP CONSTRAINT IF EXISTS [DF__T_DIGESTM__LASTC__0F582957];


GO
PRINT N'Dropping unnamed constraint on [dbo].[T_DIGESTMESSAGEQUEUE]...';


GO
ALTER TABLE [dbo].[T_DIGESTMESSAGEQUEUE] DROP CONSTRAINT IF EXISTS [DF__T_DIGESTM__SERIA__0E64051E];


GO
PRINT N'Dropping unnamed constraint on [dbo].[T_EMAILADATOK]...';


GO
ALTER TABLE [dbo].[T_EMAILADATOK] DROP CONSTRAINT IF EXISTS [DF__T_EMAILAD__SERIA__7D39791C];


GO
PRINT N'Dropping unnamed constraint on [dbo].[T_EMAILADATOK]...';


GO
ALTER TABLE [dbo].[T_EMAILADATOK] DROP CONSTRAINT IF EXISTS [DF__T_EMAILAD__LASTC__7E2D9D55];


GO
PRINT N'Dropping unnamed constraint on [dbo].[T_EMAILADATOK]...';


GO
ALTER TABLE [dbo].[T_EMAILADATOK] DROP CONSTRAINT IF EXISTS [DF__T_EMAILAD__CREAT__7F21C18E];


GO
PRINT N'Dropping unnamed constraint on [dbo].[T_EMAILADATOK]...';


GO
ALTER TABLE [dbo].[T_EMAILADATOK] DROP CONSTRAINT IF EXISTS [DF__T_EMAILAD__TOROL__7C4554E3];


GO
PRINT N'Dropping unnamed constraint on [dbo].[T_EMAILHIBALOG]...';


GO
ALTER TABLE [dbo].[T_EMAILHIBALOG] DROP CONSTRAINT IF EXISTS [DF__T_EMAILHI__LASTC__099F5001];


GO
PRINT N'Dropping unnamed constraint on [dbo].[T_EMAILHIBALOG]...';


GO
ALTER TABLE [dbo].[T_EMAILHIBALOG] DROP CONSTRAINT IF EXISTS [DF__T_EMAILHI__SERIA__08AB2BC8];


GO
PRINT N'Dropping unnamed constraint on [dbo].[T_EMAILHIBALOG]...';


GO
ALTER TABLE [dbo].[T_EMAILHIBALOG] DROP CONSTRAINT IF EXISTS [DF__T_EMAILHI__TOROL__07B7078F];


GO
PRINT N'Dropping unnamed constraint on [dbo].[T_EMAILHIBALOG]...';


GO
ALTER TABLE [dbo].[T_EMAILHIBALOG] DROP CONSTRAINT IF EXISTS [DF__T_EMAILHI__CREAT__0A93743A];


GO
PRINT N'Dropping unnamed constraint on [dbo].[T_EMAILUZENET]...';


GO
ALTER TABLE [dbo].[T_EMAILUZENET] DROP CONSTRAINT IF EXISTS [DF__T_EMAILUZ__LASTC__272FB2E8];


GO
PRINT N'Dropping unnamed constraint on [dbo].[T_EMAILUZENET]...';


GO
ALTER TABLE [dbo].[T_EMAILUZENET] DROP CONSTRAINT IF EXISTS [DF__T_EMAILUZ__CREAT__2823D721];


GO
PRINT N'Dropping unnamed constraint on [dbo].[T_EMAILUZENET]...';


GO
ALTER TABLE [dbo].[T_EMAILUZENET] DROP CONSTRAINT IF EXISTS [DF__T_EMAILUZ__SERIA__263B8EAF];


GO
PRINT N'Dropping unnamed constraint on [dbo].[T_EMAILUZENET]...';


GO
ALTER TABLE [dbo].[T_EMAILUZENET] DROP CONSTRAINT IF EXISTS [DF__T_EMAILUZ__TOROL__25476A76];


GO
PRINT N'Dropping unnamed constraint on [dbo].[T_EMAILUZENET]...';


GO
ALTER TABLE [dbo].[T_EMAILUZENET] DROP CONSTRAINT IF EXISTS [DF__T_EMAILUZ__C_KUL__2453463D];


GO
PRINT N'Dropping unnamed constraint on [dbo].[T_ERRORSTATUS]...';


GO
ALTER TABLE [dbo].[T_ERRORSTATUS] DROP CONSTRAINT IF EXISTS [DF__T_ERRORST__CREAT__11CA81AE];


GO
PRINT N'Dropping unnamed constraint on [dbo].[T_ERRORSTATUS]...';


GO
ALTER TABLE [dbo].[T_ERRORSTATUS] DROP CONSTRAINT IF EXISTS [DF__T_ERRORST__SERIA__0FE2393C];


GO
PRINT N'Dropping unnamed constraint on [dbo].[T_ERRORSTATUS]...';


GO
ALTER TABLE [dbo].[T_ERRORSTATUS] DROP CONSTRAINT IF EXISTS [DF__T_ERRORST__TOROL__0EEE1503];


GO
PRINT N'Dropping unnamed constraint on [dbo].[T_ERRORSTATUS]...';


GO
ALTER TABLE [dbo].[T_ERRORSTATUS] DROP CONSTRAINT IF EXISTS [DF__T_ERRORST__LASTC__10D65D75];


GO
PRINT N'Dropping unnamed constraint on [dbo].[T_ERRORTYPE]...';


GO
ALTER TABLE [dbo].[T_ERRORTYPE] DROP CONSTRAINT IF EXISTS [DF__T_ERRORTY__SERIA__5CECA51B];


GO
PRINT N'Dropping unnamed constraint on [dbo].[T_ERRORTYPE]...';


GO
ALTER TABLE [dbo].[T_ERRORTYPE] DROP CONSTRAINT IF EXISTS [DF__T_ERRORTY__TOROL__5BF880E2];


GO
PRINT N'Dropping unnamed constraint on [dbo].[T_ERRORTYPE]...';


GO
ALTER TABLE [dbo].[T_ERRORTYPE] DROP CONSTRAINT IF EXISTS [DF__T_ERRORTY__CREAT__5ED4ED8D];


GO
PRINT N'Dropping unnamed constraint on [dbo].[T_ERRORTYPE]...';


GO
ALTER TABLE [dbo].[T_ERRORTYPE] DROP CONSTRAINT IF EXISTS [DF__T_ERRORTY__LASTC__5DE0C954];


GO
PRINT N'Dropping unnamed constraint on [dbo].[T_GLOBALLOCK]...';


GO
ALTER TABLE [dbo].[T_GLOBALLOCK] DROP CONSTRAINT IF EXISTS [DF__T_GLOBALL__CREAT__4F87BD05];


GO
PRINT N'Dropping unnamed constraint on [dbo].[T_GLOBALLOCK]...';


GO
ALTER TABLE [dbo].[T_GLOBALLOCK] DROP CONSTRAINT IF EXISTS [DF__T_GLOBALL__LASTC__4E9398CC];


GO
PRINT N'Dropping unnamed constraint on [dbo].[T_GLOBALLOCK]...';


GO
ALTER TABLE [dbo].[T_GLOBALLOCK] DROP CONSTRAINT IF EXISTS [DF__T_GLOBALL__TOROL__4CAB505A];


GO
PRINT N'Dropping unnamed constraint on [dbo].[T_GLOBALLOCK]...';


GO
ALTER TABLE [dbo].[T_GLOBALLOCK] DROP CONSTRAINT IF EXISTS [DF__T_GLOBALL__SERIA__4D9F7493];


GO
PRINT N'Dropping unnamed constraint on [dbo].[T_MESSAGE]...';


GO
ALTER TABLE [dbo].[T_MESSAGE] DROP CONSTRAINT IF EXISTS [DF__T_MESSAGE__C_PRO__7F41BD1F];


GO
PRINT N'Dropping unnamed constraint on [dbo].[T_MESSAGE]...';


GO
ALTER TABLE [dbo].[T_MESSAGE] DROP CONSTRAINT IF EXISTS [DF__T_MESSAGE__SERIA__0406723C];


GO
PRINT N'Dropping unnamed constraint on [dbo].[T_MESSAGE]...';


GO
ALTER TABLE [dbo].[T_MESSAGE] DROP CONSTRAINT IF EXISTS [DF__T_MESSAGE__C_DIG__021E29CA];


GO
PRINT N'Dropping unnamed constraint on [dbo].[T_MESSAGE]...';


GO
ALTER TABLE [dbo].[T_MESSAGE] DROP CONSTRAINT IF EXISTS [DF__T_MESSAGE__TOROL__03124E03];


GO
PRINT N'Dropping unnamed constraint on [dbo].[T_MESSAGE]...';


GO
ALTER TABLE [dbo].[T_MESSAGE] DROP CONSTRAINT IF EXISTS [DF__T_MESSAGE__LASTC__04FA9675];


GO
PRINT N'Dropping unnamed constraint on [dbo].[T_MESSAGE]...';


GO
ALTER TABLE [dbo].[T_MESSAGE] DROP CONSTRAINT IF EXISTS [DF__T_MESSAGE__CREAT__05EEBAAE];


GO
PRINT N'Dropping unnamed constraint on [dbo].[T_MESSAGE]...';


GO
ALTER TABLE [dbo].[T_MESSAGE] DROP CONSTRAINT IF EXISTS [DF__T_MESSAGE__C_EMA__0035E158];


GO
PRINT N'Dropping unnamed constraint on [dbo].[T_MESSAGE]...';


GO
ALTER TABLE [dbo].[T_MESSAGE] DROP CONSTRAINT IF EXISTS [DF__T_MESSAGE__C_KOT__012A0591];


GO
PRINT N'Dropping unnamed constraint on [dbo].[T_MESSAGESTATUS]...';


GO
ALTER TABLE [dbo].[T_MESSAGESTATUS] DROP CONSTRAINT IF EXISTS [DF__T_MESSAGE__SERIA__36BC0F3B];


GO
PRINT N'Dropping unnamed constraint on [dbo].[T_MESSAGESTATUS]...';


GO
ALTER TABLE [dbo].[T_MESSAGESTATUS] DROP CONSTRAINT IF EXISTS [DF__T_MESSAGE__LASTC__37B03374];


GO
PRINT N'Dropping unnamed constraint on [dbo].[T_MESSAGESTATUS]...';


GO
ALTER TABLE [dbo].[T_MESSAGESTATUS] DROP CONSTRAINT IF EXISTS [DF__T_MESSAGE__TOROL__35C7EB02];


GO
PRINT N'Dropping unnamed constraint on [dbo].[T_MESSAGESTATUS]...';


GO
ALTER TABLE [dbo].[T_MESSAGESTATUS] DROP CONSTRAINT IF EXISTS [DF__T_MESSAGE__CREAT__38A457AD];


GO
PRINT N'Dropping unnamed constraint on [dbo].[T_PERSONMESSAGE]...';


GO
ALTER TABLE [dbo].[T_PERSONMESSAGE] DROP CONSTRAINT IF EXISTS [DF__T_PERSONM__LASTC__7B712C3B];


GO
PRINT N'Dropping unnamed constraint on [dbo].[T_PERSONMESSAGE]...';


GO
ALTER TABLE [dbo].[T_PERSONMESSAGE] DROP CONSTRAINT IF EXISTS [DF__T_PERSONM__SERIA__7A7D0802];


GO
PRINT N'Dropping unnamed constraint on [dbo].[T_PERSONMESSAGE]...';


GO
ALTER TABLE [dbo].[T_PERSONMESSAGE] DROP CONSTRAINT IF EXISTS [DF__T_PERSONM__CREAT__7C655074];


GO
PRINT N'Dropping unnamed constraint on [dbo].[T_PERSONMESSAGE]...';


GO
ALTER TABLE [dbo].[T_PERSONMESSAGE] DROP CONSTRAINT IF EXISTS [DF__T_PERSONM__C_SEC__7894BF90];


GO
PRINT N'Dropping unnamed constraint on [dbo].[T_PERSONMESSAGE]...';


GO
ALTER TABLE [dbo].[T_PERSONMESSAGE] DROP CONSTRAINT IF EXISTS [DF__T_PERSONM__TOROL__7988E3C9];


GO
PRINT N'Dropping unnamed constraint on [dbo].[T_SMS]...';


GO
ALTER TABLE [dbo].[T_SMS] DROP CONSTRAINT IF EXISTS [DF__T_SMS__TOROLT__3548C815];


GO
PRINT N'Dropping unnamed constraint on [dbo].[T_SMS]...';


GO
ALTER TABLE [dbo].[T_SMS] DROP CONSTRAINT IF EXISTS [DF__T_SMS__LASTCHANG__37311087];


GO
PRINT N'Dropping unnamed constraint on [dbo].[T_SMS]...';


GO
ALTER TABLE [dbo].[T_SMS] DROP CONSTRAINT IF EXISTS [DF__T_SMS__SERIAL__363CEC4E];


GO
PRINT N'Dropping unnamed constraint on [dbo].[T_SMS]...';


GO
ALTER TABLE [dbo].[T_SMS] DROP CONSTRAINT IF EXISTS [DF__T_SMS__C_ISINSTI__3454A3DC];


GO
PRINT N'Dropping unnamed constraint on [dbo].[T_SMS]...';


GO
ALTER TABLE [dbo].[T_SMS] DROP CONSTRAINT IF EXISTS [DF__T_SMS__CREATED__382534C0];


GO
PRINT N'Dropping unnamed constraint on [dbo].[T_SMSMESSAGESTATUS]...';


GO
ALTER TABLE [dbo].[T_SMSMESSAGESTATUS] DROP CONSTRAINT IF EXISTS [DF__T_SMSMESS__LASTC__3CE9E9DD];


GO
PRINT N'Dropping unnamed constraint on [dbo].[T_SMSMESSAGESTATUS]...';


GO
ALTER TABLE [dbo].[T_SMSMESSAGESTATUS] DROP CONSTRAINT IF EXISTS [DF__T_SMSMESS__TOROL__3B01A16B];


GO
PRINT N'Dropping unnamed constraint on [dbo].[T_SMSMESSAGESTATUS]...';


GO
ALTER TABLE [dbo].[T_SMSMESSAGESTATUS] DROP CONSTRAINT IF EXISTS [DF__T_SMSMESS__CREAT__3DDE0E16];


GO
PRINT N'Dropping unnamed constraint on [dbo].[T_SMSMESSAGESTATUS]...';


GO
ALTER TABLE [dbo].[T_SMSMESSAGESTATUS] DROP CONSTRAINT IF EXISTS [DF__T_SMSMESS__SERIA__3BF5C5A4];


GO
PRINT N'Dropping unnamed constraint on [dbo].[T_USERNOTIFICATION]...';


GO
ALTER TABLE [dbo].[T_USERNOTIFICATION] DROP CONSTRAINT IF EXISTS [DF__T_USERNOT__C_SMS__4E1475DF];


GO
PRINT N'Dropping unnamed constraint on [dbo].[T_USERNOTIFICATION]...';


GO
ALTER TABLE [dbo].[T_USERNOTIFICATION] DROP CONSTRAINT IF EXISTS [DF__T_USERNOT__TOROL__50F0E28A];


GO
PRINT N'Dropping unnamed constraint on [dbo].[T_USERNOTIFICATION]...';


GO
ALTER TABLE [dbo].[T_USERNOTIFICATION] DROP CONSTRAINT IF EXISTS [DF__T_USERNOT__C_EMA__4D2051A6];


GO
PRINT N'Dropping unnamed constraint on [dbo].[T_USERNOTIFICATION]...';


GO
ALTER TABLE [dbo].[T_USERNOTIFICATION] DROP CONSTRAINT IF EXISTS [DF__T_USERNOT__LASTC__52D92AFC];


GO
PRINT N'Dropping unnamed constraint on [dbo].[T_USERNOTIFICATION]...';


GO
ALTER TABLE [dbo].[T_USERNOTIFICATION] DROP CONSTRAINT IF EXISTS [DF__T_USERNOT__C_DEM__4F089A18];


GO
PRINT N'Dropping unnamed constraint on [dbo].[T_USERNOTIFICATION]...';


GO
ALTER TABLE [dbo].[T_USERNOTIFICATION] DROP CONSTRAINT IF EXISTS [DF__T_USERNOT__C_DME__4FFCBE51];


GO
PRINT N'Dropping unnamed constraint on [dbo].[T_USERNOTIFICATION]...';


GO
ALTER TABLE [dbo].[T_USERNOTIFICATION] DROP CONSTRAINT IF EXISTS [DF__T_USERNOT__CREAT__53CD4F35];


GO
PRINT N'Dropping unnamed constraint on [dbo].[T_USERNOTIFICATION]...';


GO
ALTER TABLE [dbo].[T_USERNOTIFICATION] DROP CONSTRAINT IF EXISTS [DF__T_USERNOT__SERIA__51E506C3];


GO
PRINT N'Dropping unnamed constraint on [dbo].[T_UZENET]...';


GO
ALTER TABLE [dbo].[T_UZENET] DROP CONSTRAINT IF EXISTS [DF__T_UZENET__TOROLT__2B947552];


GO
PRINT N'Dropping unnamed constraint on [dbo].[T_UZENET]...';


GO
ALTER TABLE [dbo].[T_UZENET] DROP CONSTRAINT IF EXISTS [DF__T_UZENET__LASTCH__2D7CBDC4];


GO
PRINT N'Dropping unnamed constraint on [dbo].[T_UZENET]...';


GO
ALTER TABLE [dbo].[T_UZENET] DROP CONSTRAINT IF EXISTS [DF__T_UZENET__SERIAL__2C88998B];


GO
PRINT N'Dropping unnamed constraint on [dbo].[T_UZENET]...';


GO
ALTER TABLE [dbo].[T_UZENET] DROP CONSTRAINT IF EXISTS [DF__T_UZENET__C_ERTE__2AA05119];


GO
PRINT N'Dropping unnamed constraint on [dbo].[T_UZENET]...';


GO
ALTER TABLE [dbo].[T_UZENET] DROP CONSTRAINT IF EXISTS [DF__T_UZENET__CREATE__2E70E1FD];


GO
PRINT N'Dropping unnamed constraint on [dbo].[T_UZENETCIMZETT]...';


GO
ALTER TABLE [dbo].[T_UZENETCIMZETT] DROP CONSTRAINT IF EXISTS [DF__T_UZENETC__C_OLV__1E3A7A34];


GO
PRINT N'Dropping unnamed constraint on [dbo].[T_UZENETCIMZETT]...';


GO
ALTER TABLE [dbo].[T_UZENETCIMZETT] DROP CONSTRAINT IF EXISTS [DF__T_UZENETC__C_ARC__1D4655FB];


GO
PRINT N'Dropping unnamed constraint on [dbo].[T_UZENETCIMZETT]...';


GO
ALTER TABLE [dbo].[T_UZENETCIMZETT] DROP CONSTRAINT IF EXISTS [DF__T_UZENETC__LASTC__2116E6DF];


GO
PRINT N'Dropping unnamed constraint on [dbo].[T_UZENETCIMZETT]...';


GO
ALTER TABLE [dbo].[T_UZENETCIMZETT] DROP CONSTRAINT IF EXISTS [DF__T_UZENETC__TOROL__1F2E9E6D];


GO
PRINT N'Dropping unnamed constraint on [dbo].[T_UZENETCIMZETT]...';


GO
ALTER TABLE [dbo].[T_UZENETCIMZETT] DROP CONSTRAINT IF EXISTS [DF__T_UZENETC__CREAT__220B0B18];


GO
PRINT N'Dropping unnamed constraint on [dbo].[T_UZENETCIMZETT]...';


GO
ALTER TABLE [dbo].[T_UZENETCIMZETT] DROP CONSTRAINT IF EXISTS [DF__T_UZENETC__SERIA__2022C2A6];


GO
PRINT N'Dropping unnamed constraint on [dbo].[T_UZENETJOGKORTIPUS]...';


GO
ALTER TABLE [dbo].[T_UZENETJOGKORTIPUS] DROP CONSTRAINT IF EXISTS [DF__T_UZENETJ__LASTC__26CFC035];


GO
PRINT N'Dropping unnamed constraint on [dbo].[T_UZENETJOGKORTIPUS]...';


GO
ALTER TABLE [dbo].[T_UZENETJOGKORTIPUS] DROP CONSTRAINT IF EXISTS [DF__T_UZENETJ__CREAT__27C3E46E];


GO
PRINT N'Dropping unnamed constraint on [dbo].[T_UZENETJOGKORTIPUS]...';


GO
ALTER TABLE [dbo].[T_UZENETJOGKORTIPUS] DROP CONSTRAINT IF EXISTS [DF__T_UZENETJ__SERIA__25DB9BFC];


GO
PRINT N'Dropping unnamed constraint on [dbo].[T_UZENETJOGKORTIPUS]...';


GO
ALTER TABLE [dbo].[T_UZENETJOGKORTIPUS] DROP CONSTRAINT IF EXISTS [DF__T_UZENETJ__TOROL__24E777C3];


GO
PRINT N'Dropping unnamed constraint on [dbo].[T_UZENETJOGOK]...';


GO
ALTER TABLE [dbo].[T_UZENETJOGOK] DROP CONSTRAINT IF EXISTS [DF__T_UZENETJ__C_CSA__314D4EA8];


GO
PRINT N'Dropping unnamed constraint on [dbo].[T_UZENETJOGOK]...';


GO
ALTER TABLE [dbo].[T_UZENETJOGOK] DROP CONSTRAINT IF EXISTS [DF__T_UZENETJ__LASTC__3429BB53];


GO
PRINT N'Dropping unnamed constraint on [dbo].[T_UZENETJOGOK]...';


GO
ALTER TABLE [dbo].[T_UZENETJOGOK] DROP CONSTRAINT IF EXISTS [DF__T_UZENETJ__TOROL__324172E1];


GO
PRINT N'Dropping unnamed constraint on [dbo].[T_UZENETJOGOK]...';


GO
ALTER TABLE [dbo].[T_UZENETJOGOK] DROP CONSTRAINT IF EXISTS [DF__T_UZENETJ__SERIA__3335971A];


GO
PRINT N'Dropping unnamed constraint on [dbo].[T_UZENETJOGOK]...';


GO
ALTER TABLE [dbo].[T_UZENETJOGOK] DROP CONSTRAINT IF EXISTS [DF__T_UZENETJ__CREAT__351DDF8C];


GO
PRINT N'Dropping [dbo].[FK_2240663_2240661]...';


GO
ALTER TABLE [dbo].[T_APPOINTMENT] DROP CONSTRAINT IF EXISTS [FK_2240663_2240661];


GO
PRINT N'Dropping [dbo].[FK_4023669_4023667]...';


GO
ALTER TABLE [dbo].[T_PERSONMESSAGE] DROP CONSTRAINT IF EXISTS [FK_4023669_4023667];


GO
PRINT N'Dropping [dbo].[FK_3940526_3940524]...';


GO
ALTER TABLE [dbo].[T_EMAILHIBALOG] DROP CONSTRAINT IF EXISTS [FK_3940526_3940524];


GO
PRINT N'Dropping [dbo].[FK_3940552_3940551]...';


GO
ALTER TABLE [dbo].[T_EMAILADATOK] DROP CONSTRAINT IF EXISTS [FK_3940552_3940551];


GO
PRINT N'Dropping [dbo].[FK_3940523_3940521]...';


GO
ALTER TABLE [dbo].[T_EMAILHIBALOG] DROP CONSTRAINT IF EXISTS [FK_3940523_3940521];


GO
PRINT N'Dropping [dbo].[FK_3310226_3310224]...';


GO
ALTER TABLE [dbo].[T_PERSONMESSAGE] DROP CONSTRAINT IF EXISTS [FK_3310226_3310224];


GO
PRINT N'Dropping [dbo].[FK_3940555_3940554]...';


GO
ALTER TABLE [dbo].[T_EMAILADATOK] DROP CONSTRAINT IF EXISTS [FK_3940555_3940554];


GO
PRINT N'Dropping [dbo].[FK_2190524_2190522]...';


GO
ALTER TABLE [dbo].[T_APPOINTMENT] DROP CONSTRAINT IF EXISTS [FK_2190524_2190522];


GO
PRINT N'Dropping [dbo].[FK_3911929_3911928]...';


GO
ALTER TABLE [dbo].[T_DIGESTMESSAGEQUEUE] DROP CONSTRAINT IF EXISTS [FK_3911929_3911928];


GO
PRINT N'Dropping [dbo].[FK_3911948_3911947]...';


GO
ALTER TABLE [dbo].[T_DIGESTMESSAGEQUEUE] DROP CONSTRAINT IF EXISTS [FK_3911948_3911947];


GO
PRINT N'Dropping [dbo].[FK_32249_32229]...';


GO
ALTER TABLE [dbo].[T_PERSONMESSAGE] DROP CONSTRAINT IF EXISTS [FK_32249_32229];


GO
PRINT N'Dropping [dbo].[FK_3941824_3941822]...';


GO
ALTER TABLE [dbo].[T_EMAILADATOK] DROP CONSTRAINT IF EXISTS [FK_3941824_3941822];


GO
PRINT N'Dropping [dbo].[FK_3940467_3940977]...';


GO
ALTER TABLE [dbo].[T_DIGESTEMAILMESSAGE] DROP CONSTRAINT IF EXISTS [FK_3940467_3940977];


GO
PRINT N'Dropping [dbo].[FK_3310188_3310509]...';


GO
ALTER TABLE [dbo].[T_EMAILUZENET] DROP CONSTRAINT IF EXISTS [FK_3310188_3310509];


GO
PRINT N'Dropping [dbo].[FK_2885169_2885168]...';


GO
ALTER TABLE [dbo].[T_PERSONMESSAGE] DROP CONSTRAINT IF EXISTS [FK_2885169_2885168];


GO
PRINT N'Dropping [dbo].[FK_1361985_1362201]...';


GO
ALTER TABLE [dbo].[T_SMS] DROP CONSTRAINT IF EXISTS [FK_1361985_1362201];


GO
PRINT N'Dropping [dbo].[FK_4028262_4028260]...';


GO
ALTER TABLE [dbo].[T_UZENETCIMZETT] DROP CONSTRAINT IF EXISTS [FK_4028262_4028260];


GO
PRINT N'Dropping [dbo].[FK_4028244_4028253]...';


GO
ALTER TABLE [dbo].[T_UZENETJOGOK] DROP CONSTRAINT IF EXISTS [FK_4028244_4028253];


GO
PRINT N'Dropping [dbo].[FK_4028244_4028255]...';


GO
ALTER TABLE [dbo].[T_UZENETJOGOK] DROP CONSTRAINT IF EXISTS [FK_4028244_4028255];


GO
PRINT N'Dropping [dbo].[FK_218658802_218658800]...';


GO
ALTER TABLE [dbo].[T_APPOINTMENT] DROP CONSTRAINT IF EXISTS [FK_218658802_218658800];


GO
PRINT N'Dropping [dbo].[FK_218658805_218658803]...';


GO
ALTER TABLE [dbo].[T_APPOINTMENT] DROP CONSTRAINT IF EXISTS [FK_218658805_218658803];


GO
PRINT N'Dropping [dbo].[FK_4023650_4023652]...';


GO
ALTER TABLE [dbo].[T_AUTOMATICMESSAGES] DROP CONSTRAINT IF EXISTS [FK_4023650_4023652];


GO
PRINT N'Dropping [dbo].[FK_402365002_402365000]...';


GO
ALTER TABLE [dbo].[T_AUTOMATICMESSAGES] DROP CONSTRAINT IF EXISTS [FK_402365002_402365000];


GO
PRINT N'Dropping [dbo].[FK_402365005_402365003]...';


GO
ALTER TABLE [dbo].[T_AUTOMATICMESSAGES] DROP CONSTRAINT IF EXISTS [FK_402365005_402365003];


GO
PRINT N'Dropping [dbo].[FK_394046702_394046700]...';


GO
ALTER TABLE [dbo].[T_DIGESTEMAILMESSAGE] DROP CONSTRAINT IF EXISTS [FK_394046702_394046700];


GO
PRINT N'Dropping [dbo].[FK_394046705_394046703]...';


GO
ALTER TABLE [dbo].[T_DIGESTEMAILMESSAGE] DROP CONSTRAINT IF EXISTS [FK_394046705_394046703];


GO
PRINT N'Dropping [dbo].[FK_3911920_3912879]...';


GO
ALTER TABLE [dbo].[T_DIGESTMESSAGEQUEUE] DROP CONSTRAINT IF EXISTS [FK_3911920_3912879];


GO
PRINT N'Dropping [dbo].[FK_3911920_3912884]...';


GO
ALTER TABLE [dbo].[T_DIGESTMESSAGEQUEUE] DROP CONSTRAINT IF EXISTS [FK_3911920_3912884];


GO
PRINT N'Dropping [dbo].[FK_3911977_3911975]...';


GO
ALTER TABLE [dbo].[T_DIGESTMESSAGEQUEUE] DROP CONSTRAINT IF EXISTS [FK_3911977_3911975];


GO
PRINT N'Dropping [dbo].[FK_391192002_391192000]...';


GO
ALTER TABLE [dbo].[T_DIGESTMESSAGEQUEUE] DROP CONSTRAINT IF EXISTS [FK_391192002_391192000];


GO
PRINT N'Dropping [dbo].[FK_391192005_391192003]...';


GO
ALTER TABLE [dbo].[T_DIGESTMESSAGEQUEUE] DROP CONSTRAINT IF EXISTS [FK_391192005_391192003];


GO
PRINT N'Dropping [dbo].[FK_3940527_3941607]...';


GO
ALTER TABLE [dbo].[T_EMAILADATOK] DROP CONSTRAINT IF EXISTS [FK_3940527_3941607];


GO
PRINT N'Dropping [dbo].[FK_3940536_3940534]...';


GO
ALTER TABLE [dbo].[T_EMAILADATOK] DROP CONSTRAINT IF EXISTS [FK_3940536_3940534];


GO
PRINT N'Dropping [dbo].[FK_3940546_3940544]...';


GO
ALTER TABLE [dbo].[T_EMAILADATOK] DROP CONSTRAINT IF EXISTS [FK_3940546_3940544];


GO
PRINT N'Dropping [dbo].[FK_394052702_394052700]...';


GO
ALTER TABLE [dbo].[T_EMAILADATOK] DROP CONSTRAINT IF EXISTS [FK_394052702_394052700];


GO
PRINT N'Dropping [dbo].[FK_394052705_394052703]...';


GO
ALTER TABLE [dbo].[T_EMAILADATOK] DROP CONSTRAINT IF EXISTS [FK_394052705_394052703];


GO
PRINT N'Dropping [dbo].[FK_394046502_394046500]...';


GO
ALTER TABLE [dbo].[T_EMAILHIBALOG] DROP CONSTRAINT IF EXISTS [FK_394046502_394046500];


GO
PRINT N'Dropping [dbo].[FK_394046505_394046503]...';


GO
ALTER TABLE [dbo].[T_EMAILHIBALOG] DROP CONSTRAINT IF EXISTS [FK_394046505_394046503];


GO
PRINT N'Dropping [dbo].[FK_331018802_331018800]...';


GO
ALTER TABLE [dbo].[T_EMAILUZENET] DROP CONSTRAINT IF EXISTS [FK_331018802_331018800];


GO
PRINT N'Dropping [dbo].[FK_331018805_331018803]...';


GO
ALTER TABLE [dbo].[T_EMAILUZENET] DROP CONSTRAINT IF EXISTS [FK_331018805_331018803];


GO
PRINT N'Dropping [dbo].[FK_T_21038_539881]...';


GO
ALTER TABLE [dbo].[T_ERRORSTATUS] DROP CONSTRAINT IF EXISTS [FK_T_21038_539881];


GO
PRINT N'Dropping [dbo].[FK_53988002_53988000]...';


GO
ALTER TABLE [dbo].[T_ERRORSTATUS] DROP CONSTRAINT IF EXISTS [FK_53988002_53988000];


GO
PRINT N'Dropping [dbo].[FK_53988005_53988003]...';


GO
ALTER TABLE [dbo].[T_ERRORSTATUS] DROP CONSTRAINT IF EXISTS [FK_53988005_53988003];


GO
PRINT N'Dropping [dbo].[FK_T_21038_48468]...';


GO
ALTER TABLE [dbo].[T_ERRORTYPE] DROP CONSTRAINT IF EXISTS [FK_T_21038_48468];


GO
PRINT N'Dropping [dbo].[FK_1047702_1047700]...';


GO
ALTER TABLE [dbo].[T_ERRORTYPE] DROP CONSTRAINT IF EXISTS [FK_1047702_1047700];


GO
PRINT N'Dropping [dbo].[FK_1047705_1047703]...';


GO
ALTER TABLE [dbo].[T_ERRORTYPE] DROP CONSTRAINT IF EXISTS [FK_1047705_1047703];


GO
PRINT N'Dropping [dbo].[FK_8800_3359635]...';


GO
ALTER TABLE [dbo].[T_MESSAGE] DROP CONSTRAINT IF EXISTS [FK_8800_3359635];


GO
PRINT N'Dropping [dbo].[FK_32284_32262]...';


GO
ALTER TABLE [dbo].[T_MESSAGE] DROP CONSTRAINT IF EXISTS [FK_32284_32262];


GO
PRINT N'Dropping [dbo].[FK_880002_880000]...';


GO
ALTER TABLE [dbo].[T_MESSAGE] DROP CONSTRAINT IF EXISTS [FK_880002_880000];


GO
PRINT N'Dropping [dbo].[FK_880005_880003]...';


GO
ALTER TABLE [dbo].[T_MESSAGE] DROP CONSTRAINT IF EXISTS [FK_880005_880003];


GO
PRINT N'Dropping [dbo].[FK_T_21038_4025927]...';


GO
ALTER TABLE [dbo].[T_MESSAGESTATUS] DROP CONSTRAINT IF EXISTS [FK_T_21038_4025927];


GO
PRINT N'Dropping [dbo].[FK_402592602_402592600]...';


GO
ALTER TABLE [dbo].[T_MESSAGESTATUS] DROP CONSTRAINT IF EXISTS [FK_402592602_402592600];


GO
PRINT N'Dropping [dbo].[FK_402592605_402592603]...';


GO
ALTER TABLE [dbo].[T_MESSAGESTATUS] DROP CONSTRAINT IF EXISTS [FK_402592605_402592603];


GO
PRINT N'Dropping [dbo].[FK_881102_881100]...';


GO
ALTER TABLE [dbo].[T_PERSONMESSAGE] DROP CONSTRAINT IF EXISTS [FK_881102_881100];


GO
PRINT N'Dropping [dbo].[FK_881105_881103]...';


GO
ALTER TABLE [dbo].[T_PERSONMESSAGE] DROP CONSTRAINT IF EXISTS [FK_881105_881103];


GO
PRINT N'Dropping [dbo].[FK_32236_32229]...';


GO
ALTER TABLE [dbo].[T_PERSONMESSAGE] DROP CONSTRAINT IF EXISTS [FK_32236_32229];


GO
PRINT N'Dropping [dbo].[FK_1361988_1361986]...';


GO
ALTER TABLE [dbo].[T_SMS] DROP CONSTRAINT IF EXISTS [FK_1361988_1361986];


GO
PRINT N'Dropping [dbo].[FK_136198502_136198500]...';


GO
ALTER TABLE [dbo].[T_SMS] DROP CONSTRAINT IF EXISTS [FK_136198502_136198500];


GO
PRINT N'Dropping [dbo].[FK_136198505_136198503]...';


GO
ALTER TABLE [dbo].[T_SMS] DROP CONSTRAINT IF EXISTS [FK_136198505_136198503];


GO
PRINT N'Dropping [dbo].[FK_T_21038_1364185]...';


GO
ALTER TABLE [dbo].[T_SMSMESSAGESTATUS] DROP CONSTRAINT IF EXISTS [FK_T_21038_1364185];


GO
PRINT N'Dropping [dbo].[FK_136178502_136178500]...';


GO
ALTER TABLE [dbo].[T_SMSMESSAGESTATUS] DROP CONSTRAINT IF EXISTS [FK_136178502_136178500];


GO
PRINT N'Dropping [dbo].[FK_136178505_136178503]...';


GO
ALTER TABLE [dbo].[T_SMSMESSAGESTATUS] DROP CONSTRAINT IF EXISTS [FK_136178505_136178503];


GO
PRINT N'Dropping [dbo].[FK_1257831_2831508]...';


GO
ALTER TABLE [dbo].[T_USERNOTIFICATION] DROP CONSTRAINT IF EXISTS [FK_1257831_2831508];


GO
PRINT N'Dropping [dbo].[FK_4025012_4025010]...';


GO
ALTER TABLE [dbo].[T_USERNOTIFICATION] DROP CONSTRAINT IF EXISTS [FK_4025012_4025010];


GO
PRINT N'Dropping [dbo].[FK_125783102_125783100]...';


GO
ALTER TABLE [dbo].[T_USERNOTIFICATION] DROP CONSTRAINT IF EXISTS [FK_125783102_125783100];


GO
PRINT N'Dropping [dbo].[FK_125783105_125783103]...';


GO
ALTER TABLE [dbo].[T_USERNOTIFICATION] DROP CONSTRAINT IF EXISTS [FK_125783105_125783103];


GO
PRINT N'Dropping [dbo].[FK_4028264_4028263]...';


GO
ALTER TABLE [dbo].[T_UZENET] DROP CONSTRAINT IF EXISTS [FK_4028264_4028263];


GO
PRINT N'Dropping [dbo].[FK_402824802_402824800]...';


GO
ALTER TABLE [dbo].[T_UZENET] DROP CONSTRAINT IF EXISTS [FK_402824802_402824800];


GO
PRINT N'Dropping [dbo].[FK_402824805_402824803]...';


GO
ALTER TABLE [dbo].[T_UZENET] DROP CONSTRAINT IF EXISTS [FK_402824805_402824803];


GO
PRINT N'Dropping [dbo].[FK_4028268_4028266]...';


GO
ALTER TABLE [dbo].[T_UZENETCIMZETT] DROP CONSTRAINT IF EXISTS [FK_4028268_4028266];


GO
PRINT N'Dropping [dbo].[FK_402825702_402825700]...';


GO
ALTER TABLE [dbo].[T_UZENETCIMZETT] DROP CONSTRAINT IF EXISTS [FK_402825702_402825700];


GO
PRINT N'Dropping [dbo].[FK_402825705_402825703]...';


GO
ALTER TABLE [dbo].[T_UZENETCIMZETT] DROP CONSTRAINT IF EXISTS [FK_402825705_402825703];


GO
PRINT N'Dropping [dbo].[FK_T_21038_4028269]...';


GO
ALTER TABLE [dbo].[T_UZENETJOGKORTIPUS] DROP CONSTRAINT IF EXISTS [FK_T_21038_4028269];


GO
PRINT N'Dropping [dbo].[FK_402825602_402825600]...';


GO
ALTER TABLE [dbo].[T_UZENETJOGKORTIPUS] DROP CONSTRAINT IF EXISTS [FK_402825602_402825600];


GO
PRINT N'Dropping [dbo].[FK_402825605_402825603]...';


GO
ALTER TABLE [dbo].[T_UZENETJOGKORTIPUS] DROP CONSTRAINT IF EXISTS [FK_402825605_402825603];


GO
PRINT N'Dropping [dbo].[FK_402824402_402824400]...';


GO
ALTER TABLE [dbo].[T_UZENETJOGOK] DROP CONSTRAINT IF EXISTS [FK_402824402_402824400];


GO
PRINT N'Dropping [dbo].[FK_402824405_402824403]...';


GO
ALTER TABLE [dbo].[T_UZENETJOGOK] DROP CONSTRAINT IF EXISTS [FK_402824405_402824403];


GO
PRINT N'Dropping [dbo].[T_GLOBALLOCK]...';


GO
DROP TABLE IF EXISTS [dbo].[T_GLOBALLOCK];


GO
PRINT N'Dropping [dbo].[T_APPOINTMENT_OSSZES]...';


GO
DROP VIEW IF EXISTS [dbo].[T_APPOINTMENT_OSSZES];


GO
PRINT N'Dropping [dbo].[T_AUTOMATICMESSAGES_OSSZES]...';


GO
DROP VIEW IF EXISTS [dbo].[T_AUTOMATICMESSAGES_OSSZES];


GO
PRINT N'Dropping [dbo].[T_DIGESTEMAILMESSAGE_OSSZES]...';


GO
DROP VIEW IF EXISTS [dbo].[T_DIGESTEMAILMESSAGE_OSSZES];


GO
PRINT N'Dropping [dbo].[T_DIGESTMESSAGEQUEUE_OSSZES]...';


GO
DROP VIEW IF EXISTS [dbo].[T_DIGESTMESSAGEQUEUE_OSSZES];


GO
PRINT N'Dropping [dbo].[T_EMAILADATOK_OSSZES]...';


GO
DROP VIEW IF EXISTS [dbo].[T_EMAILADATOK_OSSZES];


GO
PRINT N'Dropping [dbo].[T_EMAILHIBALOG_OSSZES]...';


GO
DROP VIEW IF EXISTS [dbo].[T_EMAILHIBALOG_OSSZES];


GO
PRINT N'Dropping [dbo].[T_EMAILUZENET_OSSZES]...';


GO
DROP VIEW IF EXISTS [dbo].[T_EMAILUZENET_OSSZES];


GO
PRINT N'Dropping [dbo].[T_ERRORSTATUS_OSSZES]...';


GO
DROP VIEW IF EXISTS [dbo].[T_ERRORSTATUS_OSSZES];


GO
PRINT N'Dropping [dbo].[T_ERRORTYPE_OSSZES]...';


GO
DROP VIEW IF EXISTS [dbo].[T_ERRORTYPE_OSSZES];


GO
PRINT N'Dropping [dbo].[T_MESSAGE_OSSZES]...';


GO
DROP VIEW IF EXISTS [dbo].[T_MESSAGE_OSSZES];


GO
PRINT N'Dropping [dbo].[T_MESSAGESTATUS_OSSZES]...';


GO
DROP VIEW IF EXISTS [dbo].[T_MESSAGESTATUS_OSSZES];


GO
PRINT N'Dropping [dbo].[T_PERSONMESSAGE_OSSZES]...';


GO
DROP VIEW IF EXISTS [dbo].[T_PERSONMESSAGE_OSSZES];


GO
PRINT N'Dropping [dbo].[T_SMS_OSSZES]...';


GO
DROP VIEW IF EXISTS [dbo].[T_SMS_OSSZES];


GO
PRINT N'Dropping [dbo].[T_SMSMESSAGESTATUS_OSSZES]...';


GO
DROP VIEW IF EXISTS [dbo].[T_SMSMESSAGESTATUS_OSSZES];


GO
PRINT N'Dropping [dbo].[T_USERNOTIFICATION_OSSZES]...';


GO
DROP VIEW IF EXISTS [dbo].[T_USERNOTIFICATION_OSSZES];


GO
PRINT N'Dropping [dbo].[T_UZENET_OSSZES]...';


GO
DROP VIEW IF EXISTS [dbo].[T_UZENET_OSSZES];


GO
PRINT N'Dropping [dbo].[T_UZENETCIMZETT_OSSZES]...';


GO
DROP VIEW IF EXISTS [dbo].[T_UZENETCIMZETT_OSSZES];


GO
PRINT N'Dropping [dbo].[T_UZENETJOGKORTIPUS_OSSZES]...';


GO
DROP VIEW IF EXISTS [dbo].[T_UZENETJOGKORTIPUS_OSSZES];


GO
PRINT N'Dropping [dbo].[T_UZENETJOGOK_OSSZES]...';


GO
DROP VIEW IF EXISTS [dbo].[T_UZENETJOGOK_OSSZES];


GO

DELETE FROM T_DICTIONARYITEMBASE 
WHERE C_TYPE IN (N'MessageStatus', N'SMSMessageStatus', N'UzenetJogkorTipus')
GO

DELETE FROM T_DICTIONARYTYPE 
WHERE C_CODENAME IN (N'MessageStatus', N'SMSMessageStatus', N'UzenetJogkorTipus')
GO

PRINT N'Dropping [dbo].[T_APPOINTMENT]...';
GO

DROP TABLE IF EXISTS [dbo].[T_APPOINTMENT];


GO
PRINT N'Dropping [dbo].[T_AUTOMATICMESSAGES]...';


GO
DROP TABLE IF EXISTS [dbo].[T_AUTOMATICMESSAGES];


GO
PRINT N'Dropping [dbo].[T_DIGESTEMAILMESSAGE]...';


GO
DROP TABLE IF EXISTS [dbo].[T_DIGESTEMAILMESSAGE];


GO
PRINT N'Dropping [dbo].[T_DIGESTMESSAGEQUEUE]...';


GO
DROP TABLE IF EXISTS [dbo].[T_DIGESTMESSAGEQUEUE];


GO
PRINT N'Dropping [dbo].[T_EMAILADATOK]...';


GO
DROP TABLE IF EXISTS [dbo].[T_EMAILADATOK];


GO
PRINT N'Dropping [dbo].[T_EMAILHIBALOG]...';


GO
DROP TABLE IF EXISTS [dbo].[T_EMAILHIBALOG];


GO
PRINT N'Dropping [dbo].[T_EMAILUZENET]...';


GO
DROP TABLE IF EXISTS [dbo].[T_EMAILUZENET];


GO
PRINT N'Dropping [dbo].[T_ERRORSTATUS]...';


GO
DROP TABLE IF EXISTS [dbo].[T_ERRORSTATUS];


GO
PRINT N'Dropping [dbo].[T_ERRORTYPE]...';


GO
DROP TABLE IF EXISTS [dbo].[T_ERRORTYPE];


GO
PRINT N'Dropping [dbo].[T_MESSAGE]...';


GO
DROP TABLE IF EXISTS [dbo].[T_MESSAGE];


GO
PRINT N'Dropping [dbo].[T_MESSAGESTATUS]...';


GO
DROP TABLE IF EXISTS [dbo].[T_MESSAGESTATUS];


GO
PRINT N'Dropping [dbo].[T_PERSONMESSAGE]...';


GO
DROP TABLE IF EXISTS [dbo].[T_PERSONMESSAGE];


GO
PRINT N'Dropping [dbo].[T_SMS]...';


GO
DROP TABLE IF EXISTS [dbo].[T_SMS];


GO
PRINT N'Dropping [dbo].[T_SMSMESSAGESTATUS]...';


GO
DROP TABLE IF EXISTS [dbo].[T_SMSMESSAGESTATUS];


GO
PRINT N'Dropping [dbo].[T_USERNOTIFICATION]...';


GO
DROP TABLE IF EXISTS [dbo].[T_USERNOTIFICATION];


GO
PRINT N'Dropping [dbo].[T_UZENET]...';


GO
DROP TABLE IF EXISTS [dbo].[T_UZENET];


GO
PRINT N'Dropping [dbo].[T_UZENETCIMZETT]...';


GO
DROP TABLE IF EXISTS [dbo].[T_UZENETCIMZETT];


GO
PRINT N'Dropping [dbo].[T_UZENETJOGKORTIPUS]...';


GO
DROP TABLE IF EXISTS [dbo].[T_UZENETJOGKORTIPUS];


GO
PRINT N'Dropping [dbo].[T_UZENETJOGOK]...';


GO
DROP TABLE IF EXISTS [dbo].[T_UZENETJOGOK];


GO
PRINT N'Refreshing [dbo].[sp_Global_CreateDictionaryItems]...';


GO
EXECUTE sp_refreshsqlmodule N'[dbo].[sp_Global_CreateDictionaryItems]';


GO
PRINT N'Update complete.';


GO
