﻿GO
SET ANSI_NULLS, ANSI_PADDING, ANSI_WARNINGS, ARITHABORT, CONCAT_NULL_YIELDS_NULL, QUOTED_IDENTIFIER ON;

SET NUMERIC_ROUNDABORT OFF;


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


GO
ALTER TABLE [dbo].[T_KULFOLDISTATUSZTIPUS] DROP CONSTRAINT [FK_T_21038_1768082];


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


GO
ALTER TABLE [dbo].[T_MULASZTASSTATISZTIKATIPUS] DROP CONSTRAINT [FK_T_21038_4026079];


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


GO
ALTER TABLE [dbo].[T_MARITALSTATUS] DROP CONSTRAINT [FK_T_21038_48369];


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


GO
ALTER TABLE [dbo].[T_SCCARDBEVONASOKA] DROP CONSTRAINT [FK_T_21038_3832194];


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


GO
ALTER TABLE [dbo].[T_IKTKOMPETENCIASZINT] DROP CONSTRAINT [FK_T_21038_4027465];


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


GO
ALTER TABLE [dbo].[T_ERTESITESSZINTIPUS] DROP CONSTRAINT [FK_T_21038_4025882];


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


GO
ALTER TABLE [dbo].[T_OKTATASINEVELESIFELADAT] DROP CONSTRAINT [FK_T_21038_4025391];


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


GO
ALTER TABLE [dbo].[T_IMPOSITIONSTATUS] DROP CONSTRAINT [FK_T_21038_48373];


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


GO
ALTER TABLE [dbo].[T_MEGYE] DROP CONSTRAINT [FK_T_21038_3715847];


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


GO
ALTER TABLE [dbo].[T_ENAPLOHASZNALAT] DROP CONSTRAINT [FK_T_21038_4027467];


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


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


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


GO
ALTER TABLE [dbo].[T_ERTELMIFOGYATEKOSTIPUS] DROP CONSTRAINT [FK_T_21038_4025374];


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


GO
ALTER TABLE [dbo].[T_ESLADATTIPUS] DROP CONSTRAINT [FK_T_21038_4026676];


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


GO
ALTER TABLE [dbo].[T_LANGUAGE] DROP CONSTRAINT [FK_T_21038_48362];


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


GO
ALTER TABLE [dbo].[T_ANYANYELV] DROP CONSTRAINT [FK_T_21038_4025161];


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


GO
ALTER TABLE [dbo].[T_TAGOZATTIPUS] DROP CONSTRAINT [FK_T_21038_4027401];


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


GO
ALTER TABLE [dbo].[T_TEVEKENYSEGTIPUS] DROP CONSTRAINT [FK_T_21038_4025861];


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


GO
ALTER TABLE [dbo].[T_HALLASSERULTTIPUS] DROP CONSTRAINT [FK_T_21038_4025375];


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


GO
ALTER TABLE [dbo].[T_CIMTIPUS] DROP CONSTRAINT [FK_T_21038_48323];


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


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


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


GO
ALTER TABLE [dbo].[T_HELYETTESITESTIPUS] DROP CONSTRAINT [FK_T_21038_4025640];


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


GO
ALTER TABLE [dbo].[T_IGAZOLVANYTIPUS] DROP CONSTRAINT [FK_T_21038_4025162];


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


GO
ALTER TABLE [dbo].[T_LATASSERULTTIPUS] DROP CONSTRAINT [FK_T_21038_4025373];


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


GO
ALTER TABLE [dbo].[T_SOROLASOKATIPUS] DROP CONSTRAINT [FK_T_21038_4026543];


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


GO
ALTER TABLE [dbo].[T_NEM] DROP CONSTRAINT [FK_T_21038_48370];


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


GO
ALTER TABLE [dbo].[T_TRANSACTIONANALYSISFILESTATU] DROP CONSTRAINT [FK_T_21038_1312031];


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


GO
ALTER TABLE [dbo].[T_MUNKAVISZONYTIPUS] DROP CONSTRAINT [FK_T_21038_4025163];


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


GO
ALTER TABLE [dbo].[T_ETKEZESIKEDVEZMENYTIPUS] DROP CONSTRAINT [FK_T_21038_4025361];


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


GO
ALTER TABLE [dbo].[T_ORSZAGTIPUS] DROP CONSTRAINT [FK_T_21038_1291259];


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


GO
ALTER TABLE [dbo].[T_HONAPOK] DROP CONSTRAINT [FK_T_21038_3044532];


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


GO
ALTER TABLE [dbo].[T_HATRANYOSHELYZETTIPUS] DROP CONSTRAINT [FK_T_21038_4025363];


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


GO
ALTER TABLE [dbo].[T_RENDSZERBEALLITASTIPUS] DROP CONSTRAINT [FK_T_21038_4026040];


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


GO
ALTER TABLE [dbo].[T_ELETPALYAMODELLFOKOZATTIPUS] DROP CONSTRAINT [FK_T_21038_4025811];


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


GO
ALTER TABLE [dbo].[T_VALLAS] DROP CONSTRAINT [FK_T_21038_4025362];


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


GO
ALTER TABLE [dbo].[T_ESZKOZTIPUS] DROP CONSTRAINT [FK_T_21038_4025131];


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


GO
ALTER TABLE [dbo].[T_MUNKAIDOKEDVEZMENYOKA] DROP CONSTRAINT [FK_T_21038_4026367];


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


GO
ALTER TABLE [dbo].[T_FELVETELSTATUSZATIPUS] DROP CONSTRAINT [FK_T_21038_4027400];


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


GO
ALTER TABLE [dbo].[T_ELETPALYAMODELLSTATUSZOK] DROP CONSTRAINT [FK_T_21038_4025812];


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


GO
ALTER TABLE [dbo].[T_ESEMENYSTATUSZ] DROP CONSTRAINT [FK_T_21038_1257632];


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


GO
ALTER TABLE [dbo].[T_ESZKOZKATEGORIA] DROP CONSTRAINT [FK_T_21038_4025132];


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


GO
ALTER TABLE [dbo].[T_KEPESITES] DROP CONSTRAINT [FK_T_21038_4026357];


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


GO
ALTER TABLE [dbo].[T_DIAKIGAZOLVANYIGENYHIBASTATU] DROP CONSTRAINT [FK_T_21038_2847546];


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


GO
ALTER TABLE [dbo].[T_ESEMENYZARADEKTIPUS] DROP CONSTRAINT [FK_T_21038_4025798];


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


GO
ALTER TABLE [dbo].[T_TRANSACTIONSTATUS] DROP CONSTRAINT [FK_T_21038_1029472];


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


GO
ALTER TABLE [dbo].[T_IDOKERET] DROP CONSTRAINT [FK_T_21038_4027209];


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


GO
ALTER TABLE [dbo].[T_DIAKIGAZOLVANYIGENYTIPUS] DROP CONSTRAINT [FK_T_21038_2846551];


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


GO
ALTER TABLE [dbo].[T_KIZAROCSOPORTTIPUS] DROP CONSTRAINT [FK_T_21038_4026039];


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


GO
ALTER TABLE [dbo].[T_PEDAGOGUSSTATUSZ] DROP CONSTRAINT [FK_T_21038_4026345];


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


GO
ALTER TABLE [dbo].[T_INGYENESTANKONYVELLATAS] DROP CONSTRAINT [FK_T_21038_4025097];


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


GO
ALTER TABLE [dbo].[T_OSSZEGTULLEPESTIPUS] DROP CONSTRAINT [FK_T_21038_4027210];


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


GO
ALTER TABLE [dbo].[T_KRETATIPUS] DROP CONSTRAINT [FK_T_21038_4026341];


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


GO
ALTER TABLE [dbo].[T_SYSTEMPARAMETERTYPE] DROP CONSTRAINT [FK_T_21038_2740820];


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


GO
ALTER TABLE [dbo].[T_TEREMTIPUS] DROP CONSTRAINT [FK_T_21038_4025095];


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


GO
ALTER TABLE [dbo].[T_TANTERVIJELLEG] DROP CONSTRAINT [FK_T_21038_4025337];


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


GO
ALTER TABLE [dbo].[T_MAGANTANULOSAGOKA] DROP CONSTRAINT [FK_T_21038_4025094];


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


GO
ALTER TABLE [dbo].[T_TESTNEVELESTIPUS] DROP CONSTRAINT [FK_T_21038_4025290];


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


GO
ALTER TABLE [dbo].[T_EPENZTARCATETELSTATUSZ] DROP CONSTRAINT [FK_T_21038_4027208];


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


GO
ALTER TABLE [dbo].[T_FORMTYPE] DROP CONSTRAINT [FK_T_21038_4025014];


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


GO
ALTER TABLE [dbo].[T_ESZKOZJELLEG] DROP CONSTRAINT [FK_T_21038_4025292];


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


GO
ALTER TABLE [dbo].[T_MAGATARTASERTEKELESTIPUS] DROP CONSTRAINT [FK_T_21038_4025744];


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


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


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


GO
ALTER TABLE [dbo].[T_HETNAPJATIPUS] DROP CONSTRAINT [FK_T_21038_4025455];


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


GO
ALTER TABLE [dbo].[T_ESZKOZCEL] DROP CONSTRAINT [FK_T_21038_4025291];


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


GO
ALTER TABLE [dbo].[T_SZORGALOMERTEKELESTIPUS] DROP CONSTRAINT [FK_T_21038_4025745];


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


GO
ALTER TABLE [dbo].[T_OTPJELENTESSTATUS] DROP CONSTRAINT [FK_T_21038_2491313];


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


GO
ALTER TABLE [dbo].[T_MERTEKEGYSEGTIPUS] DROP CONSTRAINT [FK_T_21038_4025289];


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


GO
ALTER TABLE [dbo].[T_HETIRENDTIPUS] DROP CONSTRAINT [FK_T_21038_4025453];


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


GO
ALTER TABLE [dbo].[T_HIBAJEGYSTATUSZ] DROP CONSTRAINT [FK_T_21038_4026955];


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


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


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


GO
ALTER TABLE [dbo].[T_EVENTTYPE] DROP CONSTRAINT [FK_T_21038_4025902];


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


GO
ALTER TABLE [dbo].[T_RESZSZAKKEPESITESTIPUS] DROP CONSTRAINT [FK_T_21038_4027552];


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


GO
ALTER TABLE [dbo].[T_ESEMENYTIPUS] DROP CONSTRAINT [FK_T_21038_4025716];


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


GO
ALTER TABLE [dbo].[T_OTPJELENTESTIPUS] DROP CONSTRAINT [FK_T_21038_2488607];


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


GO
ALTER TABLE [dbo].[T_NAPTIPUS] DROP CONSTRAINT [FK_T_21038_4025454];


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


GO
ALTER TABLE [dbo].[T_FENNTARTOTIPUS] DROP CONSTRAINT [FK_T_21038_4025245];


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


GO
ALTER TABLE [dbo].[T_PRIORITAS] DROP CONSTRAINT [FK_T_21038_4026956];


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


GO
ALTER TABLE [dbo].[T_FEETYPE] DROP CONSTRAINT [FK_T_21038_283802];


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


GO
ALTER TABLE [dbo].[T_SZEREPKORTIPUS] DROP CONSTRAINT [FK_T_21038_4026190];


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


GO
ALTER TABLE [dbo].[T_AGAZATTIPUS] DROP CONSTRAINT [FK_T_21038_4027554];


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


GO
ALTER TABLE [dbo].[T_IGAZOLASTIPUS] DROP CONSTRAINT [FK_T_21038_4025697];


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


GO
ALTER TABLE [dbo].[T_KOZTERULETJELLEG] DROP CONSTRAINT [FK_T_21038_2425121];


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


GO
ALTER TABLE [dbo].[T_FOGLALKOZASTIPUS] DROP CONSTRAINT [FK_T_21038_4025438];


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


GO
ALTER TABLE [dbo].[T_CSOPORTTIPUS] DROP CONSTRAINT [FK_T_21038_4025243];


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


GO
ALTER TABLE [dbo].[T_FORRAS] DROP CONSTRAINT [FK_T_21038_4026954];


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


GO
ALTER TABLE [dbo].[T_PAYMENTTITLETYPE] DROP CONSTRAINT [FK_T_21038_228252];


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


GO
ALTER TABLE [dbo].[T_SZAKMACSOPORTTIPUS] DROP CONSTRAINT [FK_T_21038_4027553];


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


GO
ALTER TABLE [dbo].[T_ROKONSAGIFOK] DROP CONSTRAINT [FK_T_21038_4025189];


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


GO
ALTER TABLE [dbo].[T_SZERZODOSZEMELYPOZICIO] DROP CONSTRAINT [FK_T_21038_4026714];


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


GO
ALTER TABLE [dbo].[T_EMAILTIPUS] DROP CONSTRAINT [FK_T_21038_48446];


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


GO
ALTER TABLE [dbo].[T_PARTFILLSTATUS] DROP CONSTRAINT [FK_T_21038_4026163];


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


GO
ALTER TABLE [dbo].[T_SZAKKEPESITESTIPUS] DROP CONSTRAINT [FK_T_21038_4027551];


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


GO
ALTER TABLE [dbo].[T_MULASZTASTIPUS] DROP CONSTRAINT [FK_T_21038_4025677];


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


GO
ALTER TABLE [dbo].[T_ENAPLOTIPUS] DROP CONSTRAINT [FK_T_21038_4026713];


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


GO
ALTER TABLE [dbo].[T_TELEFONTIPUS] DROP CONSTRAINT [FK_T_21038_48448];


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


GO
ALTER TABLE [dbo].[T_MUKODESIHELYTIPUS] DROP CONSTRAINT [FK_T_21038_4027517];


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


GO
ALTER TABLE [dbo].[T_TARGYKATEGORIATIPUS] DROP CONSTRAINT [FK_T_21038_4025413];


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


GO
ALTER TABLE [dbo].[T_ENAPLOFORRAS] DROP CONSTRAINT [FK_T_21038_4026712];


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


GO
ALTER TABLE [dbo].[T_PAYINGTYPE] DROP CONSTRAINT [FK_T_21038_48355];


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


GO
ALTER TABLE [dbo].[T_IKTESZKOZHASZNALATMOD] DROP CONSTRAINT [FK_T_21038_4027466];


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


GO
ALTER TABLE [dbo].[T_STUDENTCARDTYPE] DROP CONSTRAINT [FK_T_21038_48470];


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


GO
ALTER TABLE [dbo].[T_EVFOLYAMTIPUS] DROP CONSTRAINT [FK_T_21038_4025414];


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


GO
ALTER TABLE [dbo].[T_ERTEKELESMOD] DROP CONSTRAINT [FK_T_21038_4025675];


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


GO
ALTER TABLE [dbo].[T_DIAKIGAZOLVANYIGENYSTATUSZ] DROP CONSTRAINT [FK_T_21038_2026498];


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


GO
ALTER TABLE [dbo].[T_ALLAMPOLGARSAG] DROP CONSTRAINT [FK_T_21038_48368];


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


GO
ALTER TABLE [dbo].[T_ELSODLEGESIKTESZKOZ] DROP CONSTRAINT [FK_T_21038_4027468];


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


GO
ALTER TABLE [dbo].[T_OSZTALYZATTIPUS] DROP CONSTRAINT [FK_T_21038_4025678];


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


GO
ALTER TABLE [dbo].[T_SCSTICKERSTATUS] DROP CONSTRAINT [FK_T_21038_2026496];


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


GO
ALTER TABLE [dbo].[T_SYSTEMSETTINGSCONTROLTYPE] DROP CONSTRAINT [FK_T_21038_4026110];


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


GO
ALTER TABLE [dbo].[T_ENAPLOINFRA] DROP CONSTRAINT [FK_T_21038_4026711];


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


GO
ALTER TABLE [dbo].[T_STUDENTCARDSTATUS] DROP CONSTRAINT [FK_T_21038_48328];


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


GO
ALTER TABLE [dbo].[T_ERTESITESTIPUS] DROP CONSTRAINT [FK_T_21038_4025883];


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


GO
ALTER TABLE [dbo].[T_MUNKAKORTIPUS] DROP CONSTRAINT [FK_T_21038_4025164];


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


GO
ALTER TABLE [dbo].[T_ERTEKELESTIPUS] DROP CONSTRAINT [FK_T_21038_4025676];


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


GO
ALTER TABLE [dbo].[T_MUNKAVISZONYJELLEGE] DROP CONSTRAINT [FK_T_21038_1931621];


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


GO
ALTER TABLE [dbo].[T_NATIONALITY] DROP CONSTRAINT [FK_T_21038_48367];


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


GO
ALTER TABLE [dbo].[T_WIFIELERES] DROP CONSTRAINT [FK_T_21038_4027469];


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


GO
ALTER TABLE [dbo].[T_DICTIONARYITEMBASE] DROP CONSTRAINT [FK_2103802_2103800];


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


GO
ALTER TABLE [dbo].[T_DICTIONARYITEMBASE] DROP CONSTRAINT [FK_2103805_2103803];


GO
PRINT N'Starting rebuilding table [dbo].[T_DICTIONARYITEMBASE]...';


GO
BEGIN TRANSACTION;

SET TRANSACTION ISOLATION LEVEL SERIALIZABLE;

SET XACT_ABORT ON;

CREATE TABLE [dbo].[tmp_ms_xx_T_DICTIONARYITEMBASE] (
    [ID]            INT            IDENTITY (1, 1) NOT NULL,
    [C_VALUE]       INT            NULL,
    [C_NAME]        NVARCHAR (250) NOT NULL,
    [C_NAME_1]      NVARCHAR (250) NULL,
    [C_NAME_2]      NVARCHAR (250) NULL,
    [C_NAME_3]      NVARCHAR (250) NULL,
    [C_NAME_4]      NVARCHAR (250) NULL,
    [C_VISIBLE]     CHAR (1)       DEFAULT ('T') NOT NULL,
    [C_CODE]        NVARCHAR (20)  NULL,
    [C_TYPE]        NVARCHAR (32)  NOT NULL,
    [C_PROTECTED]   CHAR (1)       DEFAULT ('T') NOT NULL,
    [C_COLOR]       NVARCHAR (6)   NULL,
    [C_ORDER]       INT            NULL,
    [C_INTEZMENYID] INT            NOT NULL,
    [C_TANEVID]     INT            NOT NULL,
    [TOROLT]        CHAR (1)       DEFAULT ('F') NULL,
    [SERIAL]        INT            NULL,
    [LASTCHANGED]   DATETIME       DEFAULT (getdate()) NULL,
    [CREATED]       DATETIME       DEFAULT (getdate()) NULL,
    [MODIFIER]      INT            NULL,
    [CREATOR]       INT            NULL,
    CONSTRAINT [tmp_ms_xx_constraint_PK_T_210381] PRIMARY KEY CLUSTERED ([ID] ASC, [C_INTEZMENYID] ASC, [C_TANEVID] ASC)
);

IF EXISTS (SELECT TOP 1 1 
           FROM   [dbo].[T_DICTIONARYITEMBASE])
    BEGIN
        SET IDENTITY_INSERT [dbo].[tmp_ms_xx_T_DICTIONARYITEMBASE] ON;
        INSERT INTO [dbo].[tmp_ms_xx_T_DICTIONARYITEMBASE] ([ID], [C_INTEZMENYID], [C_TANEVID], [C_VALUE], [C_NAME], [C_NAME_1], [C_NAME_2], [C_NAME_3], [C_NAME_4], [C_VISIBLE], [C_TYPE], [C_PROTECTED], [TOROLT], [SERIAL], [LASTCHANGED], [CREATED], [MODIFIER], [CREATOR], [C_CODE], [C_ORDER])
        SELECT   [ID],
                 [C_INTEZMENYID],
                 [C_TANEVID],
                 [C_VALUE],
                 [C_NAME],
                 [C_NAME_1],
                 [C_NAME_2],
                 [C_NAME_3],
                 [C_NAME_4],
                 [C_VISIBLE],
                 [C_TYPE],
                 [C_PROTECTED],
                 [TOROLT],
                 [SERIAL],
                 [LASTCHANGED],
                 [CREATED],
                 [MODIFIER],
                 [CREATOR],
                 [C_CODE],
                 [C_ORDER]
        FROM     [dbo].[T_DICTIONARYITEMBASE]
        ORDER BY [ID] ASC, [C_INTEZMENYID] ASC, [C_TANEVID] ASC;
        SET IDENTITY_INSERT [dbo].[tmp_ms_xx_T_DICTIONARYITEMBASE] OFF;
    END

DROP TABLE [dbo].[T_DICTIONARYITEMBASE];

EXECUTE sp_rename N'[dbo].[tmp_ms_xx_T_DICTIONARYITEMBASE]', N'T_DICTIONARYITEMBASE';

EXECUTE sp_rename N'[dbo].[tmp_ms_xx_constraint_PK_T_210381]', N'PK_T_21038', N'OBJECT';

COMMIT TRANSACTION;

SET TRANSACTION ISOLATION LEVEL READ COMMITTED;


GO
PRINT N'Creating [dbo].[T_DICTIONARYITEMBASE].[I_T_21038_1]...';


GO
CREATE NONCLUSTERED INDEX [I_T_21038_1]
    ON [dbo].[T_DICTIONARYITEMBASE]([C_NAME] ASC, [C_TYPE] ASC);


GO
PRINT N'Creating [dbo].[T_DICTIONARYITEMBASE].[I_T_2103802_2103800]...';


GO
CREATE NONCLUSTERED INDEX [I_T_2103802_2103800]
    ON [dbo].[T_DICTIONARYITEMBASE]([C_INTEZMENYID] ASC);


GO
PRINT N'Creating [dbo].[T_DICTIONARYITEMBASE].[I_T_2103805_2103803]...';


GO
CREATE NONCLUSTERED INDEX [I_T_2103805_2103803]
    ON [dbo].[T_DICTIONARYITEMBASE]([C_TANEVID] ASC);


GO
PRINT N'Creating [dbo].[T_DICTIONARYITEMBASE].[UK_41498_3561258]...';


GO
CREATE UNIQUE NONCLUSTERED INDEX [UK_41498_3561258]
    ON [dbo].[T_DICTIONARYITEMBASE]([C_NAME] ASC, [C_TYPE] ASC, [C_INTEZMENYID] ASC, [C_TANEVID] ASC) WHERE ([TOROLT]='F');


GO
PRINT N'Creating [dbo].[FK_T_21038_1768082]...';


GO
ALTER TABLE [dbo].[T_KULFOLDISTATUSZTIPUS] WITH NOCHECK
    ADD CONSTRAINT [FK_T_21038_1768082] FOREIGN KEY ([ID], [C_ALINTEZMENYID], [C_ALTANEVID]) REFERENCES [dbo].[T_DICTIONARYITEMBASE] ([ID], [C_INTEZMENYID], [C_TANEVID]);


GO
PRINT N'Creating [dbo].[FK_T_21038_4026079]...';


GO
ALTER TABLE [dbo].[T_MULASZTASSTATISZTIKATIPUS] WITH NOCHECK
    ADD CONSTRAINT [FK_T_21038_4026079] FOREIGN KEY ([ID], [C_ALINTEZMENYID], [C_ALTANEVID]) REFERENCES [dbo].[T_DICTIONARYITEMBASE] ([ID], [C_INTEZMENYID], [C_TANEVID]);


GO
PRINT N'Creating [dbo].[FK_T_21038_48369]...';


GO
ALTER TABLE [dbo].[T_MARITALSTATUS] WITH NOCHECK
    ADD CONSTRAINT [FK_T_21038_48369] FOREIGN KEY ([ID], [C_ALINTEZMENYID], [C_ALTANEVID]) REFERENCES [dbo].[T_DICTIONARYITEMBASE] ([ID], [C_INTEZMENYID], [C_TANEVID]);


GO
PRINT N'Creating [dbo].[FK_T_21038_3832194]...';


GO
ALTER TABLE [dbo].[T_SCCARDBEVONASOKA] WITH NOCHECK
    ADD CONSTRAINT [FK_T_21038_3832194] FOREIGN KEY ([ID], [C_ALINTEZMENYID], [C_ALTANEVID]) REFERENCES [dbo].[T_DICTIONARYITEMBASE] ([ID], [C_INTEZMENYID], [C_TANEVID]);


GO
PRINT N'Creating [dbo].[FK_T_21038_4027465]...';


GO
ALTER TABLE [dbo].[T_IKTKOMPETENCIASZINT] WITH NOCHECK
    ADD CONSTRAINT [FK_T_21038_4027465] FOREIGN KEY ([ID], [C_ALINTEZMENYID], [C_ALTANEVID]) REFERENCES [dbo].[T_DICTIONARYITEMBASE] ([ID], [C_INTEZMENYID], [C_TANEVID]);


GO
PRINT N'Creating [dbo].[FK_T_21038_4025882]...';


GO
ALTER TABLE [dbo].[T_ERTESITESSZINTIPUS] WITH NOCHECK
    ADD CONSTRAINT [FK_T_21038_4025882] FOREIGN KEY ([ID], [C_ALINTEZMENYID], [C_ALTANEVID]) REFERENCES [dbo].[T_DICTIONARYITEMBASE] ([ID], [C_INTEZMENYID], [C_TANEVID]);


GO
PRINT N'Creating [dbo].[FK_T_21038_4025391]...';


GO
ALTER TABLE [dbo].[T_OKTATASINEVELESIFELADAT] WITH NOCHECK
    ADD CONSTRAINT [FK_T_21038_4025391] FOREIGN KEY ([ID], [C_ALINTEZMENYID], [C_ALTANEVID]) REFERENCES [dbo].[T_DICTIONARYITEMBASE] ([ID], [C_INTEZMENYID], [C_TANEVID]);


GO
PRINT N'Creating [dbo].[FK_T_21038_48373]...';


GO
ALTER TABLE [dbo].[T_IMPOSITIONSTATUS] WITH NOCHECK
    ADD CONSTRAINT [FK_T_21038_48373] FOREIGN KEY ([ID], [C_ALINTEZMENYID], [C_ALTANEVID]) REFERENCES [dbo].[T_DICTIONARYITEMBASE] ([ID], [C_INTEZMENYID], [C_TANEVID]);


GO
PRINT N'Creating [dbo].[FK_T_21038_3715847]...';


GO
ALTER TABLE [dbo].[T_MEGYE] WITH NOCHECK
    ADD CONSTRAINT [FK_T_21038_3715847] FOREIGN KEY ([ID], [C_ALINTEZMENYID], [C_ALTANEVID]) REFERENCES [dbo].[T_DICTIONARYITEMBASE] ([ID], [C_INTEZMENYID], [C_TANEVID]);


GO
PRINT N'Creating [dbo].[FK_T_21038_4027467]...';


GO
ALTER TABLE [dbo].[T_ENAPLOHASZNALAT] WITH NOCHECK
    ADD CONSTRAINT [FK_T_21038_4027467] FOREIGN KEY ([ID], [C_ALINTEZMENYID], [C_ALTANEVID]) REFERENCES [dbo].[T_DICTIONARYITEMBASE] ([ID], [C_INTEZMENYID], [C_TANEVID]);


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


GO
ALTER TABLE [dbo].[T_ERRORTYPE] WITH NOCHECK
    ADD CONSTRAINT [FK_T_21038_48468] FOREIGN KEY ([ID], [C_ALINTEZMENYID], [C_ALTANEVID]) REFERENCES [dbo].[T_DICTIONARYITEMBASE] ([ID], [C_INTEZMENYID], [C_TANEVID]);


GO
PRINT N'Creating [dbo].[FK_T_21038_4025374]...';


GO
ALTER TABLE [dbo].[T_ERTELMIFOGYATEKOSTIPUS] WITH NOCHECK
    ADD CONSTRAINT [FK_T_21038_4025374] FOREIGN KEY ([ID], [C_ALINTEZMENYID], [C_ALTANEVID]) REFERENCES [dbo].[T_DICTIONARYITEMBASE] ([ID], [C_INTEZMENYID], [C_TANEVID]);


GO
PRINT N'Creating [dbo].[FK_T_21038_4026676]...';


GO
ALTER TABLE [dbo].[T_ESLADATTIPUS] WITH NOCHECK
    ADD CONSTRAINT [FK_T_21038_4026676] FOREIGN KEY ([ID], [C_ALINTEZMENYID], [C_ALTANEVID]) REFERENCES [dbo].[T_DICTIONARYITEMBASE] ([ID], [C_INTEZMENYID], [C_TANEVID]);


GO
PRINT N'Creating [dbo].[FK_T_21038_48362]...';


GO
ALTER TABLE [dbo].[T_LANGUAGE] WITH NOCHECK
    ADD CONSTRAINT [FK_T_21038_48362] FOREIGN KEY ([ID], [C_ALINTEZMENYID], [C_ALTANEVID]) REFERENCES [dbo].[T_DICTIONARYITEMBASE] ([ID], [C_INTEZMENYID], [C_TANEVID]);


GO
PRINT N'Creating [dbo].[FK_T_21038_4025161]...';


GO
ALTER TABLE [dbo].[T_ANYANYELV] WITH NOCHECK
    ADD CONSTRAINT [FK_T_21038_4025161] FOREIGN KEY ([ID], [C_ALINTEZMENYID], [C_ALTANEVID]) REFERENCES [dbo].[T_DICTIONARYITEMBASE] ([ID], [C_INTEZMENYID], [C_TANEVID]);


GO
PRINT N'Creating [dbo].[FK_T_21038_4027401]...';


GO
ALTER TABLE [dbo].[T_TAGOZATTIPUS] WITH NOCHECK
    ADD CONSTRAINT [FK_T_21038_4027401] FOREIGN KEY ([ID], [C_ALINTEZMENYID], [C_ALTANEVID]) REFERENCES [dbo].[T_DICTIONARYITEMBASE] ([ID], [C_INTEZMENYID], [C_TANEVID]);


GO
PRINT N'Creating [dbo].[FK_T_21038_4025861]...';


GO
ALTER TABLE [dbo].[T_TEVEKENYSEGTIPUS] WITH NOCHECK
    ADD CONSTRAINT [FK_T_21038_4025861] FOREIGN KEY ([ID], [C_ALINTEZMENYID], [C_ALTANEVID]) REFERENCES [dbo].[T_DICTIONARYITEMBASE] ([ID], [C_INTEZMENYID], [C_TANEVID]);


GO
PRINT N'Creating [dbo].[FK_T_21038_4025375]...';


GO
ALTER TABLE [dbo].[T_HALLASSERULTTIPUS] WITH NOCHECK
    ADD CONSTRAINT [FK_T_21038_4025375] FOREIGN KEY ([ID], [C_ALINTEZMENYID], [C_ALTANEVID]) REFERENCES [dbo].[T_DICTIONARYITEMBASE] ([ID], [C_INTEZMENYID], [C_TANEVID]);


GO
PRINT N'Creating [dbo].[FK_T_21038_48323]...';


GO
ALTER TABLE [dbo].[T_CIMTIPUS] WITH NOCHECK
    ADD CONSTRAINT [FK_T_21038_48323] FOREIGN KEY ([ID], [C_ALINTEZMENYID], [C_ALTANEVID]) REFERENCES [dbo].[T_DICTIONARYITEMBASE] ([ID], [C_INTEZMENYID], [C_TANEVID]);


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


GO
ALTER TABLE [dbo].[T_SMSMESSAGESTATUS] WITH NOCHECK
    ADD CONSTRAINT [FK_T_21038_1364185] FOREIGN KEY ([ID], [C_ALINTEZMENYID], [C_ALTANEVID]) REFERENCES [dbo].[T_DICTIONARYITEMBASE] ([ID], [C_INTEZMENYID], [C_TANEVID]);


GO
PRINT N'Creating [dbo].[FK_T_21038_4025640]...';


GO
ALTER TABLE [dbo].[T_HELYETTESITESTIPUS] WITH NOCHECK
    ADD CONSTRAINT [FK_T_21038_4025640] FOREIGN KEY ([ID], [C_ALINTEZMENYID], [C_ALTANEVID]) REFERENCES [dbo].[T_DICTIONARYITEMBASE] ([ID], [C_INTEZMENYID], [C_TANEVID]);


GO
PRINT N'Creating [dbo].[FK_T_21038_4025162]...';


GO
ALTER TABLE [dbo].[T_IGAZOLVANYTIPUS] WITH NOCHECK
    ADD CONSTRAINT [FK_T_21038_4025162] FOREIGN KEY ([ID], [C_ALINTEZMENYID], [C_ALTANEVID]) REFERENCES [dbo].[T_DICTIONARYITEMBASE] ([ID], [C_INTEZMENYID], [C_TANEVID]);


GO
PRINT N'Creating [dbo].[FK_T_21038_4025373]...';


GO
ALTER TABLE [dbo].[T_LATASSERULTTIPUS] WITH NOCHECK
    ADD CONSTRAINT [FK_T_21038_4025373] FOREIGN KEY ([ID], [C_ALINTEZMENYID], [C_ALTANEVID]) REFERENCES [dbo].[T_DICTIONARYITEMBASE] ([ID], [C_INTEZMENYID], [C_TANEVID]);


GO
PRINT N'Creating [dbo].[FK_T_21038_4026543]...';


GO
ALTER TABLE [dbo].[T_SOROLASOKATIPUS] WITH NOCHECK
    ADD CONSTRAINT [FK_T_21038_4026543] FOREIGN KEY ([ID], [C_ALINTEZMENYID], [C_ALTANEVID]) REFERENCES [dbo].[T_DICTIONARYITEMBASE] ([ID], [C_INTEZMENYID], [C_TANEVID]);


GO
PRINT N'Creating [dbo].[FK_T_21038_48370]...';


GO
ALTER TABLE [dbo].[T_NEM] WITH NOCHECK
    ADD CONSTRAINT [FK_T_21038_48370] FOREIGN KEY ([ID], [C_ALINTEZMENYID], [C_ALTANEVID]) REFERENCES [dbo].[T_DICTIONARYITEMBASE] ([ID], [C_INTEZMENYID], [C_TANEVID]);


GO
PRINT N'Creating [dbo].[FK_T_21038_1312031]...';


GO
ALTER TABLE [dbo].[T_TRANSACTIONANALYSISFILESTATU] WITH NOCHECK
    ADD CONSTRAINT [FK_T_21038_1312031] FOREIGN KEY ([ID], [C_ALINTEZMENYID], [C_ALTANEVID]) REFERENCES [dbo].[T_DICTIONARYITEMBASE] ([ID], [C_INTEZMENYID], [C_TANEVID]);


GO
PRINT N'Creating [dbo].[FK_T_21038_4025163]...';


GO
ALTER TABLE [dbo].[T_MUNKAVISZONYTIPUS] WITH NOCHECK
    ADD CONSTRAINT [FK_T_21038_4025163] FOREIGN KEY ([ID], [C_ALINTEZMENYID], [C_ALTANEVID]) REFERENCES [dbo].[T_DICTIONARYITEMBASE] ([ID], [C_INTEZMENYID], [C_TANEVID]);


GO
PRINT N'Creating [dbo].[FK_T_21038_4025361]...';


GO
ALTER TABLE [dbo].[T_ETKEZESIKEDVEZMENYTIPUS] WITH NOCHECK
    ADD CONSTRAINT [FK_T_21038_4025361] FOREIGN KEY ([ID], [C_ALINTEZMENYID], [C_ALTANEVID]) REFERENCES [dbo].[T_DICTIONARYITEMBASE] ([ID], [C_INTEZMENYID], [C_TANEVID]);


GO
PRINT N'Creating [dbo].[FK_T_21038_1291259]...';


GO
ALTER TABLE [dbo].[T_ORSZAGTIPUS] WITH NOCHECK
    ADD CONSTRAINT [FK_T_21038_1291259] FOREIGN KEY ([ID], [C_ALINTEZMENYID], [C_ALTANEVID]) REFERENCES [dbo].[T_DICTIONARYITEMBASE] ([ID], [C_INTEZMENYID], [C_TANEVID]);


GO
PRINT N'Creating [dbo].[FK_T_21038_3044532]...';


GO
ALTER TABLE [dbo].[T_HONAPOK] WITH NOCHECK
    ADD CONSTRAINT [FK_T_21038_3044532] FOREIGN KEY ([ID], [C_ALINTEZMENYID], [C_ALTANEVID]) REFERENCES [dbo].[T_DICTIONARYITEMBASE] ([ID], [C_INTEZMENYID], [C_TANEVID]);


GO
PRINT N'Creating [dbo].[FK_T_21038_4025363]...';


GO
ALTER TABLE [dbo].[T_HATRANYOSHELYZETTIPUS] WITH NOCHECK
    ADD CONSTRAINT [FK_T_21038_4025363] FOREIGN KEY ([ID], [C_ALINTEZMENYID], [C_ALTANEVID]) REFERENCES [dbo].[T_DICTIONARYITEMBASE] ([ID], [C_INTEZMENYID], [C_TANEVID]);


GO
PRINT N'Creating [dbo].[FK_T_21038_4026040]...';


GO
ALTER TABLE [dbo].[T_RENDSZERBEALLITASTIPUS] WITH NOCHECK
    ADD CONSTRAINT [FK_T_21038_4026040] FOREIGN KEY ([ID], [C_ALINTEZMENYID], [C_ALTANEVID]) REFERENCES [dbo].[T_DICTIONARYITEMBASE] ([ID], [C_INTEZMENYID], [C_TANEVID]);


GO
PRINT N'Creating [dbo].[FK_T_21038_4025811]...';


GO
ALTER TABLE [dbo].[T_ELETPALYAMODELLFOKOZATTIPUS] WITH NOCHECK
    ADD CONSTRAINT [FK_T_21038_4025811] FOREIGN KEY ([ID], [C_ALINTEZMENYID], [C_ALTANEVID]) REFERENCES [dbo].[T_DICTIONARYITEMBASE] ([ID], [C_INTEZMENYID], [C_TANEVID]);


GO
PRINT N'Creating [dbo].[FK_T_21038_4025362]...';


GO
ALTER TABLE [dbo].[T_VALLAS] WITH NOCHECK
    ADD CONSTRAINT [FK_T_21038_4025362] FOREIGN KEY ([ID], [C_ALINTEZMENYID], [C_ALTANEVID]) REFERENCES [dbo].[T_DICTIONARYITEMBASE] ([ID], [C_INTEZMENYID], [C_TANEVID]);


GO
PRINT N'Creating [dbo].[FK_T_21038_4025131]...';


GO
ALTER TABLE [dbo].[T_ESZKOZTIPUS] WITH NOCHECK
    ADD CONSTRAINT [FK_T_21038_4025131] FOREIGN KEY ([ID], [C_ALINTEZMENYID], [C_ALTANEVID]) REFERENCES [dbo].[T_DICTIONARYITEMBASE] ([ID], [C_INTEZMENYID], [C_TANEVID]);


GO
PRINT N'Creating [dbo].[FK_T_21038_4026367]...';


GO
ALTER TABLE [dbo].[T_MUNKAIDOKEDVEZMENYOKA] WITH NOCHECK
    ADD CONSTRAINT [FK_T_21038_4026367] FOREIGN KEY ([ID], [C_ALINTEZMENYID], [C_ALTANEVID]) REFERENCES [dbo].[T_DICTIONARYITEMBASE] ([ID], [C_INTEZMENYID], [C_TANEVID]);


GO
PRINT N'Creating [dbo].[FK_T_21038_4027400]...';


GO
ALTER TABLE [dbo].[T_FELVETELSTATUSZATIPUS] WITH NOCHECK
    ADD CONSTRAINT [FK_T_21038_4027400] FOREIGN KEY ([ID], [C_ALINTEZMENYID], [C_ALTANEVID]) REFERENCES [dbo].[T_DICTIONARYITEMBASE] ([ID], [C_INTEZMENYID], [C_TANEVID]);


GO
PRINT N'Creating [dbo].[FK_T_21038_4025812]...';


GO
ALTER TABLE [dbo].[T_ELETPALYAMODELLSTATUSZOK] WITH NOCHECK
    ADD CONSTRAINT [FK_T_21038_4025812] FOREIGN KEY ([ID], [C_ALINTEZMENYID], [C_ALTANEVID]) REFERENCES [dbo].[T_DICTIONARYITEMBASE] ([ID], [C_INTEZMENYID], [C_TANEVID]);


GO
PRINT N'Creating [dbo].[FK_T_21038_1257632]...';


GO
ALTER TABLE [dbo].[T_ESEMENYSTATUSZ] WITH NOCHECK
    ADD CONSTRAINT [FK_T_21038_1257632] FOREIGN KEY ([ID], [C_ALINTEZMENYID], [C_ALTANEVID]) REFERENCES [dbo].[T_DICTIONARYITEMBASE] ([ID], [C_INTEZMENYID], [C_TANEVID]);


GO
PRINT N'Creating [dbo].[FK_T_21038_4025132]...';


GO
ALTER TABLE [dbo].[T_ESZKOZKATEGORIA] WITH NOCHECK
    ADD CONSTRAINT [FK_T_21038_4025132] FOREIGN KEY ([ID], [C_ALINTEZMENYID], [C_ALTANEVID]) REFERENCES [dbo].[T_DICTIONARYITEMBASE] ([ID], [C_INTEZMENYID], [C_TANEVID]);


GO
PRINT N'Creating [dbo].[FK_T_21038_4026357]...';


GO
ALTER TABLE [dbo].[T_KEPESITES] WITH NOCHECK
    ADD CONSTRAINT [FK_T_21038_4026357] FOREIGN KEY ([ID], [C_ALINTEZMENYID], [C_ALTANEVID]) REFERENCES [dbo].[T_DICTIONARYITEMBASE] ([ID], [C_INTEZMENYID], [C_TANEVID]);


GO
PRINT N'Creating [dbo].[FK_T_21038_2847546]...';


GO
ALTER TABLE [dbo].[T_DIAKIGAZOLVANYIGENYHIBASTATU] WITH NOCHECK
    ADD CONSTRAINT [FK_T_21038_2847546] FOREIGN KEY ([ID], [C_ALINTEZMENYID], [C_ALTANEVID]) REFERENCES [dbo].[T_DICTIONARYITEMBASE] ([ID], [C_INTEZMENYID], [C_TANEVID]);


GO
PRINT N'Creating [dbo].[FK_T_21038_4025798]...';


GO
ALTER TABLE [dbo].[T_ESEMENYZARADEKTIPUS] WITH NOCHECK
    ADD CONSTRAINT [FK_T_21038_4025798] FOREIGN KEY ([ID], [C_ALINTEZMENYID], [C_ALTANEVID]) REFERENCES [dbo].[T_DICTIONARYITEMBASE] ([ID], [C_INTEZMENYID], [C_TANEVID]);


GO
PRINT N'Creating [dbo].[FK_T_21038_1029472]...';


GO
ALTER TABLE [dbo].[T_TRANSACTIONSTATUS] WITH NOCHECK
    ADD CONSTRAINT [FK_T_21038_1029472] FOREIGN KEY ([ID], [C_ALINTEZMENYID], [C_ALTANEVID]) REFERENCES [dbo].[T_DICTIONARYITEMBASE] ([ID], [C_INTEZMENYID], [C_TANEVID]);


GO
PRINT N'Creating [dbo].[FK_T_21038_4027209]...';


GO
ALTER TABLE [dbo].[T_IDOKERET] WITH NOCHECK
    ADD CONSTRAINT [FK_T_21038_4027209] FOREIGN KEY ([ID], [C_ALINTEZMENYID], [C_ALTANEVID]) REFERENCES [dbo].[T_DICTIONARYITEMBASE] ([ID], [C_INTEZMENYID], [C_TANEVID]);


GO
PRINT N'Creating [dbo].[FK_T_21038_2846551]...';


GO
ALTER TABLE [dbo].[T_DIAKIGAZOLVANYIGENYTIPUS] WITH NOCHECK
    ADD CONSTRAINT [FK_T_21038_2846551] FOREIGN KEY ([ID], [C_ALINTEZMENYID], [C_ALTANEVID]) REFERENCES [dbo].[T_DICTIONARYITEMBASE] ([ID], [C_INTEZMENYID], [C_TANEVID]);


GO
PRINT N'Creating [dbo].[FK_T_21038_4026039]...';


GO
ALTER TABLE [dbo].[T_KIZAROCSOPORTTIPUS] WITH NOCHECK
    ADD CONSTRAINT [FK_T_21038_4026039] FOREIGN KEY ([ID], [C_ALINTEZMENYID], [C_ALTANEVID]) REFERENCES [dbo].[T_DICTIONARYITEMBASE] ([ID], [C_INTEZMENYID], [C_TANEVID]);


GO
PRINT N'Creating [dbo].[FK_T_21038_4026345]...';


GO
ALTER TABLE [dbo].[T_PEDAGOGUSSTATUSZ] WITH NOCHECK
    ADD CONSTRAINT [FK_T_21038_4026345] FOREIGN KEY ([ID], [C_ALINTEZMENYID], [C_ALTANEVID]) REFERENCES [dbo].[T_DICTIONARYITEMBASE] ([ID], [C_INTEZMENYID], [C_TANEVID]);


GO
PRINT N'Creating [dbo].[FK_T_21038_4025097]...';


GO
ALTER TABLE [dbo].[T_INGYENESTANKONYVELLATAS] WITH NOCHECK
    ADD CONSTRAINT [FK_T_21038_4025097] FOREIGN KEY ([ID], [C_ALINTEZMENYID], [C_ALTANEVID]) REFERENCES [dbo].[T_DICTIONARYITEMBASE] ([ID], [C_INTEZMENYID], [C_TANEVID]);


GO
PRINT N'Creating [dbo].[FK_T_21038_4027210]...';


GO
ALTER TABLE [dbo].[T_OSSZEGTULLEPESTIPUS] WITH NOCHECK
    ADD CONSTRAINT [FK_T_21038_4027210] FOREIGN KEY ([ID], [C_ALINTEZMENYID], [C_ALTANEVID]) REFERENCES [dbo].[T_DICTIONARYITEMBASE] ([ID], [C_INTEZMENYID], [C_TANEVID]);


GO
PRINT N'Creating [dbo].[FK_T_21038_4026341]...';


GO
ALTER TABLE [dbo].[T_KRETATIPUS] WITH NOCHECK
    ADD CONSTRAINT [FK_T_21038_4026341] FOREIGN KEY ([ID], [C_ALINTEZMENYID], [C_ALTANEVID]) REFERENCES [dbo].[T_DICTIONARYITEMBASE] ([ID], [C_INTEZMENYID], [C_TANEVID]);


GO
PRINT N'Creating [dbo].[FK_T_21038_2740820]...';


GO
ALTER TABLE [dbo].[T_SYSTEMPARAMETERTYPE] WITH NOCHECK
    ADD CONSTRAINT [FK_T_21038_2740820] FOREIGN KEY ([ID], [C_ALINTEZMENYID], [C_ALTANEVID]) REFERENCES [dbo].[T_DICTIONARYITEMBASE] ([ID], [C_INTEZMENYID], [C_TANEVID]);


GO
PRINT N'Creating [dbo].[FK_T_21038_4025095]...';


GO
ALTER TABLE [dbo].[T_TEREMTIPUS] WITH NOCHECK
    ADD CONSTRAINT [FK_T_21038_4025095] FOREIGN KEY ([ID], [C_ALINTEZMENYID], [C_ALTANEVID]) REFERENCES [dbo].[T_DICTIONARYITEMBASE] ([ID], [C_INTEZMENYID], [C_TANEVID]);


GO
PRINT N'Creating [dbo].[FK_T_21038_4025337]...';


GO
ALTER TABLE [dbo].[T_TANTERVIJELLEG] WITH NOCHECK
    ADD CONSTRAINT [FK_T_21038_4025337] FOREIGN KEY ([ID], [C_ALINTEZMENYID], [C_ALTANEVID]) REFERENCES [dbo].[T_DICTIONARYITEMBASE] ([ID], [C_INTEZMENYID], [C_TANEVID]);


GO
PRINT N'Creating [dbo].[FK_T_21038_4025094]...';


GO
ALTER TABLE [dbo].[T_MAGANTANULOSAGOKA] WITH NOCHECK
    ADD CONSTRAINT [FK_T_21038_4025094] FOREIGN KEY ([ID], [C_ALINTEZMENYID], [C_ALTANEVID]) REFERENCES [dbo].[T_DICTIONARYITEMBASE] ([ID], [C_INTEZMENYID], [C_TANEVID]);


GO
PRINT N'Creating [dbo].[FK_T_21038_4025290]...';


GO
ALTER TABLE [dbo].[T_TESTNEVELESTIPUS] WITH NOCHECK
    ADD CONSTRAINT [FK_T_21038_4025290] FOREIGN KEY ([ID], [C_ALINTEZMENYID], [C_ALTANEVID]) REFERENCES [dbo].[T_DICTIONARYITEMBASE] ([ID], [C_INTEZMENYID], [C_TANEVID]);


GO
PRINT N'Creating [dbo].[FK_T_21038_4027208]...';


GO
ALTER TABLE [dbo].[T_EPENZTARCATETELSTATUSZ] WITH NOCHECK
    ADD CONSTRAINT [FK_T_21038_4027208] FOREIGN KEY ([ID], [C_ALINTEZMENYID], [C_ALTANEVID]) REFERENCES [dbo].[T_DICTIONARYITEMBASE] ([ID], [C_INTEZMENYID], [C_TANEVID]);


GO
PRINT N'Creating [dbo].[FK_T_21038_4025014]...';


GO
ALTER TABLE [dbo].[T_FORMTYPE] WITH NOCHECK
    ADD CONSTRAINT [FK_T_21038_4025014] FOREIGN KEY ([ID], [C_ALINTEZMENYID], [C_ALTANEVID]) REFERENCES [dbo].[T_DICTIONARYITEMBASE] ([ID], [C_INTEZMENYID], [C_TANEVID]);


GO
PRINT N'Creating [dbo].[FK_T_21038_4025292]...';


GO
ALTER TABLE [dbo].[T_ESZKOZJELLEG] WITH NOCHECK
    ADD CONSTRAINT [FK_T_21038_4025292] FOREIGN KEY ([ID], [C_ALINTEZMENYID], [C_ALTANEVID]) REFERENCES [dbo].[T_DICTIONARYITEMBASE] ([ID], [C_INTEZMENYID], [C_TANEVID]);


GO
PRINT N'Creating [dbo].[FK_T_21038_4025744]...';


GO
ALTER TABLE [dbo].[T_MAGATARTASERTEKELESTIPUS] WITH NOCHECK
    ADD CONSTRAINT [FK_T_21038_4025744] FOREIGN KEY ([ID], [C_ALINTEZMENYID], [C_ALTANEVID]) REFERENCES [dbo].[T_DICTIONARYITEMBASE] ([ID], [C_INTEZMENYID], [C_TANEVID]);


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


GO
ALTER TABLE [dbo].[T_MESSAGESTATUS] WITH NOCHECK
    ADD CONSTRAINT [FK_T_21038_4025927] FOREIGN KEY ([ID], [C_ALINTEZMENYID], [C_ALTANEVID]) REFERENCES [dbo].[T_DICTIONARYITEMBASE] ([ID], [C_INTEZMENYID], [C_TANEVID]);


GO
PRINT N'Creating [dbo].[FK_T_21038_4025455]...';


GO
ALTER TABLE [dbo].[T_HETNAPJATIPUS] WITH NOCHECK
    ADD CONSTRAINT [FK_T_21038_4025455] FOREIGN KEY ([ID], [C_ALINTEZMENYID], [C_ALTANEVID]) REFERENCES [dbo].[T_DICTIONARYITEMBASE] ([ID], [C_INTEZMENYID], [C_TANEVID]);


GO
PRINT N'Creating [dbo].[FK_T_21038_4025291]...';


GO
ALTER TABLE [dbo].[T_ESZKOZCEL] WITH NOCHECK
    ADD CONSTRAINT [FK_T_21038_4025291] FOREIGN KEY ([ID], [C_ALINTEZMENYID], [C_ALTANEVID]) REFERENCES [dbo].[T_DICTIONARYITEMBASE] ([ID], [C_INTEZMENYID], [C_TANEVID]);


GO
PRINT N'Creating [dbo].[FK_T_21038_4025745]...';


GO
ALTER TABLE [dbo].[T_SZORGALOMERTEKELESTIPUS] WITH NOCHECK
    ADD CONSTRAINT [FK_T_21038_4025745] FOREIGN KEY ([ID], [C_ALINTEZMENYID], [C_ALTANEVID]) REFERENCES [dbo].[T_DICTIONARYITEMBASE] ([ID], [C_INTEZMENYID], [C_TANEVID]);


GO
PRINT N'Creating [dbo].[FK_T_21038_2491313]...';


GO
ALTER TABLE [dbo].[T_OTPJELENTESSTATUS] WITH NOCHECK
    ADD CONSTRAINT [FK_T_21038_2491313] FOREIGN KEY ([ID], [C_ALINTEZMENYID], [C_ALTANEVID]) REFERENCES [dbo].[T_DICTIONARYITEMBASE] ([ID], [C_INTEZMENYID], [C_TANEVID]);


GO
PRINT N'Creating [dbo].[FK_T_21038_4025289]...';


GO
ALTER TABLE [dbo].[T_MERTEKEGYSEGTIPUS] WITH NOCHECK
    ADD CONSTRAINT [FK_T_21038_4025289] FOREIGN KEY ([ID], [C_ALINTEZMENYID], [C_ALTANEVID]) REFERENCES [dbo].[T_DICTIONARYITEMBASE] ([ID], [C_INTEZMENYID], [C_TANEVID]);


GO
PRINT N'Creating [dbo].[FK_T_21038_4025453]...';


GO
ALTER TABLE [dbo].[T_HETIRENDTIPUS] WITH NOCHECK
    ADD CONSTRAINT [FK_T_21038_4025453] FOREIGN KEY ([ID], [C_ALINTEZMENYID], [C_ALTANEVID]) REFERENCES [dbo].[T_DICTIONARYITEMBASE] ([ID], [C_INTEZMENYID], [C_TANEVID]);


GO
PRINT N'Creating [dbo].[FK_T_21038_4026955]...';


GO
ALTER TABLE [dbo].[T_HIBAJEGYSTATUSZ] WITH NOCHECK
    ADD CONSTRAINT [FK_T_21038_4026955] FOREIGN KEY ([ID], [C_ALINTEZMENYID], [C_ALTANEVID]) REFERENCES [dbo].[T_DICTIONARYITEMBASE] ([ID], [C_INTEZMENYID], [C_TANEVID]);


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


GO
ALTER TABLE [dbo].[T_ERRORSTATUS] WITH NOCHECK
    ADD CONSTRAINT [FK_T_21038_539881] FOREIGN KEY ([ID], [C_ALINTEZMENYID], [C_ALTANEVID]) REFERENCES [dbo].[T_DICTIONARYITEMBASE] ([ID], [C_INTEZMENYID], [C_TANEVID]);


GO
PRINT N'Creating [dbo].[FK_T_21038_4025902]...';


GO
ALTER TABLE [dbo].[T_EVENTTYPE] WITH NOCHECK
    ADD CONSTRAINT [FK_T_21038_4025902] FOREIGN KEY ([ID], [C_ALINTEZMENYID], [C_ALTANEVID]) REFERENCES [dbo].[T_DICTIONARYITEMBASE] ([ID], [C_INTEZMENYID], [C_TANEVID]);


GO
PRINT N'Creating [dbo].[FK_T_21038_4027552]...';


GO
ALTER TABLE [dbo].[T_RESZSZAKKEPESITESTIPUS] WITH NOCHECK
    ADD CONSTRAINT [FK_T_21038_4027552] FOREIGN KEY ([ID], [C_ALINTEZMENYID], [C_ALTANEVID]) REFERENCES [dbo].[T_DICTIONARYITEMBASE] ([ID], [C_INTEZMENYID], [C_TANEVID]);


GO
PRINT N'Creating [dbo].[FK_T_21038_4025716]...';


GO
ALTER TABLE [dbo].[T_ESEMENYTIPUS] WITH NOCHECK
    ADD CONSTRAINT [FK_T_21038_4025716] FOREIGN KEY ([ID], [C_ALINTEZMENYID], [C_ALTANEVID]) REFERENCES [dbo].[T_DICTIONARYITEMBASE] ([ID], [C_INTEZMENYID], [C_TANEVID]);


GO
PRINT N'Creating [dbo].[FK_T_21038_2488607]...';


GO
ALTER TABLE [dbo].[T_OTPJELENTESTIPUS] WITH NOCHECK
    ADD CONSTRAINT [FK_T_21038_2488607] FOREIGN KEY ([ID], [C_ALINTEZMENYID], [C_ALTANEVID]) REFERENCES [dbo].[T_DICTIONARYITEMBASE] ([ID], [C_INTEZMENYID], [C_TANEVID]);


GO
PRINT N'Creating [dbo].[FK_T_21038_4025454]...';


GO
ALTER TABLE [dbo].[T_NAPTIPUS] WITH NOCHECK
    ADD CONSTRAINT [FK_T_21038_4025454] FOREIGN KEY ([ID], [C_ALINTEZMENYID], [C_ALTANEVID]) REFERENCES [dbo].[T_DICTIONARYITEMBASE] ([ID], [C_INTEZMENYID], [C_TANEVID]);


GO
PRINT N'Creating [dbo].[FK_T_21038_4025245]...';


GO
ALTER TABLE [dbo].[T_FENNTARTOTIPUS] WITH NOCHECK
    ADD CONSTRAINT [FK_T_21038_4025245] FOREIGN KEY ([ID], [C_ALINTEZMENYID], [C_ALTANEVID]) REFERENCES [dbo].[T_DICTIONARYITEMBASE] ([ID], [C_INTEZMENYID], [C_TANEVID]);


GO
PRINT N'Creating [dbo].[FK_T_21038_4026956]...';


GO
ALTER TABLE [dbo].[T_PRIORITAS] WITH NOCHECK
    ADD CONSTRAINT [FK_T_21038_4026956] FOREIGN KEY ([ID], [C_ALINTEZMENYID], [C_ALTANEVID]) REFERENCES [dbo].[T_DICTIONARYITEMBASE] ([ID], [C_INTEZMENYID], [C_TANEVID]);


GO
PRINT N'Creating [dbo].[FK_T_21038_283802]...';


GO
ALTER TABLE [dbo].[T_FEETYPE] WITH NOCHECK
    ADD CONSTRAINT [FK_T_21038_283802] FOREIGN KEY ([ID], [C_ALINTEZMENYID], [C_ALTANEVID]) REFERENCES [dbo].[T_DICTIONARYITEMBASE] ([ID], [C_INTEZMENYID], [C_TANEVID]);


GO
PRINT N'Creating [dbo].[FK_T_21038_4026190]...';


GO
ALTER TABLE [dbo].[T_SZEREPKORTIPUS] WITH NOCHECK
    ADD CONSTRAINT [FK_T_21038_4026190] FOREIGN KEY ([ID], [C_ALINTEZMENYID], [C_ALTANEVID]) REFERENCES [dbo].[T_DICTIONARYITEMBASE] ([ID], [C_INTEZMENYID], [C_TANEVID]);


GO
PRINT N'Creating [dbo].[FK_T_21038_4027554]...';


GO
ALTER TABLE [dbo].[T_AGAZATTIPUS] WITH NOCHECK
    ADD CONSTRAINT [FK_T_21038_4027554] FOREIGN KEY ([ID], [C_ALINTEZMENYID], [C_ALTANEVID]) REFERENCES [dbo].[T_DICTIONARYITEMBASE] ([ID], [C_INTEZMENYID], [C_TANEVID]);


GO
PRINT N'Creating [dbo].[FK_T_21038_4025697]...';


GO
ALTER TABLE [dbo].[T_IGAZOLASTIPUS] WITH NOCHECK
    ADD CONSTRAINT [FK_T_21038_4025697] FOREIGN KEY ([ID], [C_ALINTEZMENYID], [C_ALTANEVID]) REFERENCES [dbo].[T_DICTIONARYITEMBASE] ([ID], [C_INTEZMENYID], [C_TANEVID]);


GO
PRINT N'Creating [dbo].[FK_T_21038_2425121]...';


GO
ALTER TABLE [dbo].[T_KOZTERULETJELLEG] WITH NOCHECK
    ADD CONSTRAINT [FK_T_21038_2425121] FOREIGN KEY ([ID], [C_ALINTEZMENYID], [C_ALTANEVID]) REFERENCES [dbo].[T_DICTIONARYITEMBASE] ([ID], [C_INTEZMENYID], [C_TANEVID]);


GO
PRINT N'Creating [dbo].[FK_T_21038_4025438]...';


GO
ALTER TABLE [dbo].[T_FOGLALKOZASTIPUS] WITH NOCHECK
    ADD CONSTRAINT [FK_T_21038_4025438] FOREIGN KEY ([ID], [C_ALINTEZMENYID], [C_ALTANEVID]) REFERENCES [dbo].[T_DICTIONARYITEMBASE] ([ID], [C_INTEZMENYID], [C_TANEVID]);


GO
PRINT N'Creating [dbo].[FK_T_21038_4025243]...';


GO
ALTER TABLE [dbo].[T_CSOPORTTIPUS] WITH NOCHECK
    ADD CONSTRAINT [FK_T_21038_4025243] FOREIGN KEY ([ID], [C_ALINTEZMENYID], [C_ALTANEVID]) REFERENCES [dbo].[T_DICTIONARYITEMBASE] ([ID], [C_INTEZMENYID], [C_TANEVID]);


GO
PRINT N'Creating [dbo].[FK_T_21038_4026954]...';


GO
ALTER TABLE [dbo].[T_FORRAS] WITH NOCHECK
    ADD CONSTRAINT [FK_T_21038_4026954] FOREIGN KEY ([ID], [C_ALINTEZMENYID], [C_ALTANEVID]) REFERENCES [dbo].[T_DICTIONARYITEMBASE] ([ID], [C_INTEZMENYID], [C_TANEVID]);


GO
PRINT N'Creating [dbo].[FK_T_21038_228252]...';


GO
ALTER TABLE [dbo].[T_PAYMENTTITLETYPE] WITH NOCHECK
    ADD CONSTRAINT [FK_T_21038_228252] FOREIGN KEY ([ID], [C_ALINTEZMENYID], [C_ALTANEVID]) REFERENCES [dbo].[T_DICTIONARYITEMBASE] ([ID], [C_INTEZMENYID], [C_TANEVID]);


GO
PRINT N'Creating [dbo].[FK_T_21038_4027553]...';


GO
ALTER TABLE [dbo].[T_SZAKMACSOPORTTIPUS] WITH NOCHECK
    ADD CONSTRAINT [FK_T_21038_4027553] FOREIGN KEY ([ID], [C_ALINTEZMENYID], [C_ALTANEVID]) REFERENCES [dbo].[T_DICTIONARYITEMBASE] ([ID], [C_INTEZMENYID], [C_TANEVID]);


GO
PRINT N'Creating [dbo].[FK_T_21038_4025189]...';


GO
ALTER TABLE [dbo].[T_ROKONSAGIFOK] WITH NOCHECK
    ADD CONSTRAINT [FK_T_21038_4025189] FOREIGN KEY ([ID], [C_ALINTEZMENYID], [C_ALTANEVID]) REFERENCES [dbo].[T_DICTIONARYITEMBASE] ([ID], [C_INTEZMENYID], [C_TANEVID]);


GO
PRINT N'Creating [dbo].[FK_T_21038_4026714]...';


GO
ALTER TABLE [dbo].[T_SZERZODOSZEMELYPOZICIO] WITH NOCHECK
    ADD CONSTRAINT [FK_T_21038_4026714] FOREIGN KEY ([ID], [C_ALINTEZMENYID], [C_ALTANEVID]) REFERENCES [dbo].[T_DICTIONARYITEMBASE] ([ID], [C_INTEZMENYID], [C_TANEVID]);


GO
PRINT N'Creating [dbo].[FK_T_21038_48446]...';


GO
ALTER TABLE [dbo].[T_EMAILTIPUS] WITH NOCHECK
    ADD CONSTRAINT [FK_T_21038_48446] FOREIGN KEY ([ID], [C_ALINTEZMENYID], [C_ALTANEVID]) REFERENCES [dbo].[T_DICTIONARYITEMBASE] ([ID], [C_INTEZMENYID], [C_TANEVID]);


GO
PRINT N'Creating [dbo].[FK_T_21038_4026163]...';


GO
ALTER TABLE [dbo].[T_PARTFILLSTATUS] WITH NOCHECK
    ADD CONSTRAINT [FK_T_21038_4026163] FOREIGN KEY ([ID], [C_ALINTEZMENYID], [C_ALTANEVID]) REFERENCES [dbo].[T_DICTIONARYITEMBASE] ([ID], [C_INTEZMENYID], [C_TANEVID]);


GO
PRINT N'Creating [dbo].[FK_T_21038_4027551]...';


GO
ALTER TABLE [dbo].[T_SZAKKEPESITESTIPUS] WITH NOCHECK
    ADD CONSTRAINT [FK_T_21038_4027551] FOREIGN KEY ([ID], [C_ALINTEZMENYID], [C_ALTANEVID]) REFERENCES [dbo].[T_DICTIONARYITEMBASE] ([ID], [C_INTEZMENYID], [C_TANEVID]);


GO
PRINT N'Creating [dbo].[FK_T_21038_4025677]...';


GO
ALTER TABLE [dbo].[T_MULASZTASTIPUS] WITH NOCHECK
    ADD CONSTRAINT [FK_T_21038_4025677] FOREIGN KEY ([ID], [C_ALINTEZMENYID], [C_ALTANEVID]) REFERENCES [dbo].[T_DICTIONARYITEMBASE] ([ID], [C_INTEZMENYID], [C_TANEVID]);


GO
PRINT N'Creating [dbo].[FK_T_21038_4026713]...';


GO
ALTER TABLE [dbo].[T_ENAPLOTIPUS] WITH NOCHECK
    ADD CONSTRAINT [FK_T_21038_4026713] FOREIGN KEY ([ID], [C_ALINTEZMENYID], [C_ALTANEVID]) REFERENCES [dbo].[T_DICTIONARYITEMBASE] ([ID], [C_INTEZMENYID], [C_TANEVID]);


GO
PRINT N'Creating [dbo].[FK_T_21038_48448]...';


GO
ALTER TABLE [dbo].[T_TELEFONTIPUS] WITH NOCHECK
    ADD CONSTRAINT [FK_T_21038_48448] FOREIGN KEY ([ID], [C_ALINTEZMENYID], [C_ALTANEVID]) REFERENCES [dbo].[T_DICTIONARYITEMBASE] ([ID], [C_INTEZMENYID], [C_TANEVID]);


GO
PRINT N'Creating [dbo].[FK_T_21038_4027517]...';


GO
ALTER TABLE [dbo].[T_MUKODESIHELYTIPUS] WITH NOCHECK
    ADD CONSTRAINT [FK_T_21038_4027517] FOREIGN KEY ([ID], [C_ALINTEZMENYID], [C_ALTANEVID]) REFERENCES [dbo].[T_DICTIONARYITEMBASE] ([ID], [C_INTEZMENYID], [C_TANEVID]);


GO
PRINT N'Creating [dbo].[FK_T_21038_4025413]...';


GO
ALTER TABLE [dbo].[T_TARGYKATEGORIATIPUS] WITH NOCHECK
    ADD CONSTRAINT [FK_T_21038_4025413] FOREIGN KEY ([ID], [C_ALINTEZMENYID], [C_ALTANEVID]) REFERENCES [dbo].[T_DICTIONARYITEMBASE] ([ID], [C_INTEZMENYID], [C_TANEVID]);


GO
PRINT N'Creating [dbo].[FK_T_21038_4026712]...';


GO
ALTER TABLE [dbo].[T_ENAPLOFORRAS] WITH NOCHECK
    ADD CONSTRAINT [FK_T_21038_4026712] FOREIGN KEY ([ID], [C_ALINTEZMENYID], [C_ALTANEVID]) REFERENCES [dbo].[T_DICTIONARYITEMBASE] ([ID], [C_INTEZMENYID], [C_TANEVID]);


GO
PRINT N'Creating [dbo].[FK_T_21038_48355]...';


GO
ALTER TABLE [dbo].[T_PAYINGTYPE] WITH NOCHECK
    ADD CONSTRAINT [FK_T_21038_48355] FOREIGN KEY ([ID], [C_ALINTEZMENYID], [C_ALTANEVID]) REFERENCES [dbo].[T_DICTIONARYITEMBASE] ([ID], [C_INTEZMENYID], [C_TANEVID]);


GO
PRINT N'Creating [dbo].[FK_T_21038_4027466]...';


GO
ALTER TABLE [dbo].[T_IKTESZKOZHASZNALATMOD] WITH NOCHECK
    ADD CONSTRAINT [FK_T_21038_4027466] FOREIGN KEY ([ID], [C_ALINTEZMENYID], [C_ALTANEVID]) REFERENCES [dbo].[T_DICTIONARYITEMBASE] ([ID], [C_INTEZMENYID], [C_TANEVID]);


GO
PRINT N'Creating [dbo].[FK_T_21038_48470]...';


GO
ALTER TABLE [dbo].[T_STUDENTCARDTYPE] WITH NOCHECK
    ADD CONSTRAINT [FK_T_21038_48470] FOREIGN KEY ([ID], [C_ALINTEZMENYID], [C_ALTANEVID]) REFERENCES [dbo].[T_DICTIONARYITEMBASE] ([ID], [C_INTEZMENYID], [C_TANEVID]);


GO
PRINT N'Creating [dbo].[FK_T_21038_4025414]...';


GO
ALTER TABLE [dbo].[T_EVFOLYAMTIPUS] WITH NOCHECK
    ADD CONSTRAINT [FK_T_21038_4025414] FOREIGN KEY ([ID], [C_ALINTEZMENYID], [C_ALTANEVID]) REFERENCES [dbo].[T_DICTIONARYITEMBASE] ([ID], [C_INTEZMENYID], [C_TANEVID]);


GO
PRINT N'Creating [dbo].[FK_T_21038_4025675]...';


GO
ALTER TABLE [dbo].[T_ERTEKELESMOD] WITH NOCHECK
    ADD CONSTRAINT [FK_T_21038_4025675] FOREIGN KEY ([ID], [C_ALINTEZMENYID], [C_ALTANEVID]) REFERENCES [dbo].[T_DICTIONARYITEMBASE] ([ID], [C_INTEZMENYID], [C_TANEVID]);


GO
PRINT N'Creating [dbo].[FK_T_21038_2026498]...';


GO
ALTER TABLE [dbo].[T_DIAKIGAZOLVANYIGENYSTATUSZ] WITH NOCHECK
    ADD CONSTRAINT [FK_T_21038_2026498] FOREIGN KEY ([ID], [C_ALINTEZMENYID], [C_ALTANEVID]) REFERENCES [dbo].[T_DICTIONARYITEMBASE] ([ID], [C_INTEZMENYID], [C_TANEVID]);


GO
PRINT N'Creating [dbo].[FK_T_21038_48368]...';


GO
ALTER TABLE [dbo].[T_ALLAMPOLGARSAG] WITH NOCHECK
    ADD CONSTRAINT [FK_T_21038_48368] FOREIGN KEY ([ID], [C_ALINTEZMENYID], [C_ALTANEVID]) REFERENCES [dbo].[T_DICTIONARYITEMBASE] ([ID], [C_INTEZMENYID], [C_TANEVID]);


GO
PRINT N'Creating [dbo].[FK_T_21038_4027468]...';


GO
ALTER TABLE [dbo].[T_ELSODLEGESIKTESZKOZ] WITH NOCHECK
    ADD CONSTRAINT [FK_T_21038_4027468] FOREIGN KEY ([ID], [C_ALINTEZMENYID], [C_ALTANEVID]) REFERENCES [dbo].[T_DICTIONARYITEMBASE] ([ID], [C_INTEZMENYID], [C_TANEVID]);


GO
PRINT N'Creating [dbo].[FK_T_21038_4025678]...';


GO
ALTER TABLE [dbo].[T_OSZTALYZATTIPUS] WITH NOCHECK
    ADD CONSTRAINT [FK_T_21038_4025678] FOREIGN KEY ([ID], [C_ALINTEZMENYID], [C_ALTANEVID]) REFERENCES [dbo].[T_DICTIONARYITEMBASE] ([ID], [C_INTEZMENYID], [C_TANEVID]);


GO
PRINT N'Creating [dbo].[FK_T_21038_2026496]...';


GO
ALTER TABLE [dbo].[T_SCSTICKERSTATUS] WITH NOCHECK
    ADD CONSTRAINT [FK_T_21038_2026496] FOREIGN KEY ([ID], [C_ALINTEZMENYID], [C_ALTANEVID]) REFERENCES [dbo].[T_DICTIONARYITEMBASE] ([ID], [C_INTEZMENYID], [C_TANEVID]);


GO
PRINT N'Creating [dbo].[FK_T_21038_4026110]...';


GO
ALTER TABLE [dbo].[T_SYSTEMSETTINGSCONTROLTYPE] WITH NOCHECK
    ADD CONSTRAINT [FK_T_21038_4026110] FOREIGN KEY ([ID], [C_ALINTEZMENYID], [C_ALTANEVID]) REFERENCES [dbo].[T_DICTIONARYITEMBASE] ([ID], [C_INTEZMENYID], [C_TANEVID]);


GO
PRINT N'Creating [dbo].[FK_T_21038_4026711]...';


GO
ALTER TABLE [dbo].[T_ENAPLOINFRA] WITH NOCHECK
    ADD CONSTRAINT [FK_T_21038_4026711] FOREIGN KEY ([ID], [C_ALINTEZMENYID], [C_ALTANEVID]) REFERENCES [dbo].[T_DICTIONARYITEMBASE] ([ID], [C_INTEZMENYID], [C_TANEVID]);


GO
PRINT N'Creating [dbo].[FK_T_21038_48328]...';


GO
ALTER TABLE [dbo].[T_STUDENTCARDSTATUS] WITH NOCHECK
    ADD CONSTRAINT [FK_T_21038_48328] FOREIGN KEY ([ID], [C_ALINTEZMENYID], [C_ALTANEVID]) REFERENCES [dbo].[T_DICTIONARYITEMBASE] ([ID], [C_INTEZMENYID], [C_TANEVID]);


GO
PRINT N'Creating [dbo].[FK_T_21038_4025883]...';


GO
ALTER TABLE [dbo].[T_ERTESITESTIPUS] WITH NOCHECK
    ADD CONSTRAINT [FK_T_21038_4025883] FOREIGN KEY ([ID], [C_ALINTEZMENYID], [C_ALTANEVID]) REFERENCES [dbo].[T_DICTIONARYITEMBASE] ([ID], [C_INTEZMENYID], [C_TANEVID]);


GO
PRINT N'Creating [dbo].[FK_T_21038_4025164]...';


GO
ALTER TABLE [dbo].[T_MUNKAKORTIPUS] WITH NOCHECK
    ADD CONSTRAINT [FK_T_21038_4025164] FOREIGN KEY ([ID], [C_ALINTEZMENYID], [C_ALTANEVID]) REFERENCES [dbo].[T_DICTIONARYITEMBASE] ([ID], [C_INTEZMENYID], [C_TANEVID]);


GO
PRINT N'Creating [dbo].[FK_T_21038_4025676]...';


GO
ALTER TABLE [dbo].[T_ERTEKELESTIPUS] WITH NOCHECK
    ADD CONSTRAINT [FK_T_21038_4025676] FOREIGN KEY ([ID], [C_ALINTEZMENYID], [C_ALTANEVID]) REFERENCES [dbo].[T_DICTIONARYITEMBASE] ([ID], [C_INTEZMENYID], [C_TANEVID]);


GO
PRINT N'Creating [dbo].[FK_T_21038_1931621]...';


GO
ALTER TABLE [dbo].[T_MUNKAVISZONYJELLEGE] WITH NOCHECK
    ADD CONSTRAINT [FK_T_21038_1931621] FOREIGN KEY ([ID], [C_ALINTEZMENYID], [C_ALTANEVID]) REFERENCES [dbo].[T_DICTIONARYITEMBASE] ([ID], [C_INTEZMENYID], [C_TANEVID]);


GO
PRINT N'Creating [dbo].[FK_T_21038_48367]...';


GO
ALTER TABLE [dbo].[T_NATIONALITY] WITH NOCHECK
    ADD CONSTRAINT [FK_T_21038_48367] FOREIGN KEY ([ID], [C_ALINTEZMENYID], [C_ALTANEVID]) REFERENCES [dbo].[T_DICTIONARYITEMBASE] ([ID], [C_INTEZMENYID], [C_TANEVID]);


GO
PRINT N'Creating [dbo].[FK_T_21038_4027469]...';


GO
ALTER TABLE [dbo].[T_WIFIELERES] WITH NOCHECK
    ADD CONSTRAINT [FK_T_21038_4027469] FOREIGN KEY ([ID], [C_ALINTEZMENYID], [C_ALTANEVID]) REFERENCES [dbo].[T_DICTIONARYITEMBASE] ([ID], [C_INTEZMENYID], [C_TANEVID]);


GO
PRINT N'Creating [dbo].[FK_2103802_2103800]...';


GO
ALTER TABLE [dbo].[T_DICTIONARYITEMBASE] WITH NOCHECK
    ADD CONSTRAINT [FK_2103802_2103800] FOREIGN KEY ([C_INTEZMENYID]) REFERENCES [dbo].[T_INTEZMENY] ([ID]);


GO
PRINT N'Creating [dbo].[FK_2103805_2103803]...';


GO
ALTER TABLE [dbo].[T_DICTIONARYITEMBASE] WITH NOCHECK
    ADD CONSTRAINT [FK_2103805_2103803] FOREIGN KEY ([C_TANEVID]) REFERENCES [dbo].[T_TANEV] ([ID]);


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


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


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


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


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


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


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


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


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


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


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


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


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


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


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


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


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


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


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


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


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


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


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


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


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


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


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


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


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


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


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


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


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


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


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


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


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


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


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


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


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


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


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


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


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


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


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


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


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


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


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


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


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


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


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


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


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


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


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


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


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


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


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


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


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


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


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


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


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


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


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


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


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


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


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


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


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


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


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


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


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


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


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


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


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


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


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


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


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


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


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


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


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


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


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


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


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


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


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


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


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


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


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


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


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


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


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


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


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


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


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


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


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


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


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


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


GO
PRINT N'Refreshing [stage].[sp_MrgDictionaryItemBase]...';


GO
EXECUTE sp_refreshsqlmodule N'[stage].[sp_MrgDictionaryItemBase]';


GO
PRINT N'Refreshing [stage].[sp_MrgEslAdat]...';


GO
EXECUTE sp_refreshsqlmodule N'[stage].[sp_MrgEslAdat]';


GO
PRINT N'Refreshing [stage].[sp_MrgFeladatellatasiHely]...';


GO
EXECUTE sp_refreshsqlmodule N'[stage].[sp_MrgFeladatellatasiHely]';


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


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


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


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


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


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


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


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


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


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


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


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


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


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


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


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


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


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


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


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


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


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


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


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


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


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


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


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


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


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


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


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


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


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


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


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


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


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


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


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


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


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


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


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


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


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


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


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


GO
PRINT N'Refreshing [stage].[sp_MrgStage]...';


GO
EXECUTE sp_refreshsqlmodule N'[stage].[sp_MrgStage]';


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


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


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


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


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


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


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


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


GO
PRINT N'Checking existing data against newly created constraints';


GO
ALTER TABLE [dbo].[T_KULFOLDISTATUSZTIPUS] WITH CHECK CHECK CONSTRAINT [FK_T_21038_1768082];

ALTER TABLE [dbo].[T_MULASZTASSTATISZTIKATIPUS] WITH CHECK CHECK CONSTRAINT [FK_T_21038_4026079];

ALTER TABLE [dbo].[T_MARITALSTATUS] WITH CHECK CHECK CONSTRAINT [FK_T_21038_48369];

ALTER TABLE [dbo].[T_SCCARDBEVONASOKA] WITH CHECK CHECK CONSTRAINT [FK_T_21038_3832194];

ALTER TABLE [dbo].[T_IKTKOMPETENCIASZINT] WITH CHECK CHECK CONSTRAINT [FK_T_21038_4027465];

ALTER TABLE [dbo].[T_ERTESITESSZINTIPUS] WITH CHECK CHECK CONSTRAINT [FK_T_21038_4025882];

ALTER TABLE [dbo].[T_OKTATASINEVELESIFELADAT] WITH CHECK CHECK CONSTRAINT [FK_T_21038_4025391];

ALTER TABLE [dbo].[T_IMPOSITIONSTATUS] WITH CHECK CHECK CONSTRAINT [FK_T_21038_48373];

ALTER TABLE [dbo].[T_MEGYE] WITH CHECK CHECK CONSTRAINT [FK_T_21038_3715847];

ALTER TABLE [dbo].[T_ENAPLOHASZNALAT] WITH CHECK CHECK CONSTRAINT [FK_T_21038_4027467];

ALTER TABLE [dbo].[T_ERRORTYPE] WITH CHECK CHECK CONSTRAINT [FK_T_21038_48468];

ALTER TABLE [dbo].[T_ERTELMIFOGYATEKOSTIPUS] WITH CHECK CHECK CONSTRAINT [FK_T_21038_4025374];

ALTER TABLE [dbo].[T_ESLADATTIPUS] WITH CHECK CHECK CONSTRAINT [FK_T_21038_4026676];

ALTER TABLE [dbo].[T_LANGUAGE] WITH CHECK CHECK CONSTRAINT [FK_T_21038_48362];

ALTER TABLE [dbo].[T_ANYANYELV] WITH CHECK CHECK CONSTRAINT [FK_T_21038_4025161];

ALTER TABLE [dbo].[T_TAGOZATTIPUS] WITH CHECK CHECK CONSTRAINT [FK_T_21038_4027401];

ALTER TABLE [dbo].[T_TEVEKENYSEGTIPUS] WITH CHECK CHECK CONSTRAINT [FK_T_21038_4025861];

ALTER TABLE [dbo].[T_HALLASSERULTTIPUS] WITH CHECK CHECK CONSTRAINT [FK_T_21038_4025375];

ALTER TABLE [dbo].[T_CIMTIPUS] WITH CHECK CHECK CONSTRAINT [FK_T_21038_48323];

ALTER TABLE [dbo].[T_SMSMESSAGESTATUS] WITH CHECK CHECK CONSTRAINT [FK_T_21038_1364185];

ALTER TABLE [dbo].[T_HELYETTESITESTIPUS] WITH CHECK CHECK CONSTRAINT [FK_T_21038_4025640];

ALTER TABLE [dbo].[T_IGAZOLVANYTIPUS] WITH CHECK CHECK CONSTRAINT [FK_T_21038_4025162];

ALTER TABLE [dbo].[T_LATASSERULTTIPUS] WITH CHECK CHECK CONSTRAINT [FK_T_21038_4025373];

ALTER TABLE [dbo].[T_SOROLASOKATIPUS] WITH CHECK CHECK CONSTRAINT [FK_T_21038_4026543];

ALTER TABLE [dbo].[T_NEM] WITH CHECK CHECK CONSTRAINT [FK_T_21038_48370];

ALTER TABLE [dbo].[T_TRANSACTIONANALYSISFILESTATU] WITH CHECK CHECK CONSTRAINT [FK_T_21038_1312031];

ALTER TABLE [dbo].[T_MUNKAVISZONYTIPUS] WITH CHECK CHECK CONSTRAINT [FK_T_21038_4025163];

ALTER TABLE [dbo].[T_ETKEZESIKEDVEZMENYTIPUS] WITH CHECK CHECK CONSTRAINT [FK_T_21038_4025361];

ALTER TABLE [dbo].[T_ORSZAGTIPUS] WITH CHECK CHECK CONSTRAINT [FK_T_21038_1291259];

ALTER TABLE [dbo].[T_HONAPOK] WITH CHECK CHECK CONSTRAINT [FK_T_21038_3044532];

ALTER TABLE [dbo].[T_HATRANYOSHELYZETTIPUS] WITH CHECK CHECK CONSTRAINT [FK_T_21038_4025363];

ALTER TABLE [dbo].[T_RENDSZERBEALLITASTIPUS] WITH CHECK CHECK CONSTRAINT [FK_T_21038_4026040];

ALTER TABLE [dbo].[T_ELETPALYAMODELLFOKOZATTIPUS] WITH CHECK CHECK CONSTRAINT [FK_T_21038_4025811];

ALTER TABLE [dbo].[T_VALLAS] WITH CHECK CHECK CONSTRAINT [FK_T_21038_4025362];

ALTER TABLE [dbo].[T_ESZKOZTIPUS] WITH CHECK CHECK CONSTRAINT [FK_T_21038_4025131];

ALTER TABLE [dbo].[T_MUNKAIDOKEDVEZMENYOKA] WITH CHECK CHECK CONSTRAINT [FK_T_21038_4026367];

ALTER TABLE [dbo].[T_FELVETELSTATUSZATIPUS] WITH CHECK CHECK CONSTRAINT [FK_T_21038_4027400];

ALTER TABLE [dbo].[T_ELETPALYAMODELLSTATUSZOK] WITH CHECK CHECK CONSTRAINT [FK_T_21038_4025812];

ALTER TABLE [dbo].[T_ESEMENYSTATUSZ] WITH CHECK CHECK CONSTRAINT [FK_T_21038_1257632];

ALTER TABLE [dbo].[T_ESZKOZKATEGORIA] WITH CHECK CHECK CONSTRAINT [FK_T_21038_4025132];

ALTER TABLE [dbo].[T_KEPESITES] WITH CHECK CHECK CONSTRAINT [FK_T_21038_4026357];

ALTER TABLE [dbo].[T_DIAKIGAZOLVANYIGENYHIBASTATU] WITH CHECK CHECK CONSTRAINT [FK_T_21038_2847546];

ALTER TABLE [dbo].[T_ESEMENYZARADEKTIPUS] WITH CHECK CHECK CONSTRAINT [FK_T_21038_4025798];

ALTER TABLE [dbo].[T_TRANSACTIONSTATUS] WITH CHECK CHECK CONSTRAINT [FK_T_21038_1029472];

ALTER TABLE [dbo].[T_IDOKERET] WITH CHECK CHECK CONSTRAINT [FK_T_21038_4027209];

ALTER TABLE [dbo].[T_DIAKIGAZOLVANYIGENYTIPUS] WITH CHECK CHECK CONSTRAINT [FK_T_21038_2846551];

ALTER TABLE [dbo].[T_KIZAROCSOPORTTIPUS] WITH CHECK CHECK CONSTRAINT [FK_T_21038_4026039];

ALTER TABLE [dbo].[T_PEDAGOGUSSTATUSZ] WITH CHECK CHECK CONSTRAINT [FK_T_21038_4026345];

ALTER TABLE [dbo].[T_INGYENESTANKONYVELLATAS] WITH CHECK CHECK CONSTRAINT [FK_T_21038_4025097];

ALTER TABLE [dbo].[T_OSSZEGTULLEPESTIPUS] WITH CHECK CHECK CONSTRAINT [FK_T_21038_4027210];

ALTER TABLE [dbo].[T_KRETATIPUS] WITH CHECK CHECK CONSTRAINT [FK_T_21038_4026341];

ALTER TABLE [dbo].[T_SYSTEMPARAMETERTYPE] WITH CHECK CHECK CONSTRAINT [FK_T_21038_2740820];

ALTER TABLE [dbo].[T_TEREMTIPUS] WITH CHECK CHECK CONSTRAINT [FK_T_21038_4025095];

ALTER TABLE [dbo].[T_TANTERVIJELLEG] WITH CHECK CHECK CONSTRAINT [FK_T_21038_4025337];

ALTER TABLE [dbo].[T_MAGANTANULOSAGOKA] WITH CHECK CHECK CONSTRAINT [FK_T_21038_4025094];

ALTER TABLE [dbo].[T_TESTNEVELESTIPUS] WITH CHECK CHECK CONSTRAINT [FK_T_21038_4025290];

ALTER TABLE [dbo].[T_EPENZTARCATETELSTATUSZ] WITH CHECK CHECK CONSTRAINT [FK_T_21038_4027208];

ALTER TABLE [dbo].[T_FORMTYPE] WITH CHECK CHECK CONSTRAINT [FK_T_21038_4025014];

ALTER TABLE [dbo].[T_ESZKOZJELLEG] WITH CHECK CHECK CONSTRAINT [FK_T_21038_4025292];

ALTER TABLE [dbo].[T_MAGATARTASERTEKELESTIPUS] WITH CHECK CHECK CONSTRAINT [FK_T_21038_4025744];

ALTER TABLE [dbo].[T_MESSAGESTATUS] WITH CHECK CHECK CONSTRAINT [FK_T_21038_4025927];

ALTER TABLE [dbo].[T_HETNAPJATIPUS] WITH CHECK CHECK CONSTRAINT [FK_T_21038_4025455];

ALTER TABLE [dbo].[T_ESZKOZCEL] WITH CHECK CHECK CONSTRAINT [FK_T_21038_4025291];

ALTER TABLE [dbo].[T_SZORGALOMERTEKELESTIPUS] WITH CHECK CHECK CONSTRAINT [FK_T_21038_4025745];

ALTER TABLE [dbo].[T_OTPJELENTESSTATUS] WITH CHECK CHECK CONSTRAINT [FK_T_21038_2491313];

ALTER TABLE [dbo].[T_MERTEKEGYSEGTIPUS] WITH CHECK CHECK CONSTRAINT [FK_T_21038_4025289];

ALTER TABLE [dbo].[T_HETIRENDTIPUS] WITH CHECK CHECK CONSTRAINT [FK_T_21038_4025453];

ALTER TABLE [dbo].[T_HIBAJEGYSTATUSZ] WITH CHECK CHECK CONSTRAINT [FK_T_21038_4026955];

ALTER TABLE [dbo].[T_ERRORSTATUS] WITH CHECK CHECK CONSTRAINT [FK_T_21038_539881];

ALTER TABLE [dbo].[T_EVENTTYPE] WITH CHECK CHECK CONSTRAINT [FK_T_21038_4025902];

ALTER TABLE [dbo].[T_RESZSZAKKEPESITESTIPUS] WITH CHECK CHECK CONSTRAINT [FK_T_21038_4027552];

ALTER TABLE [dbo].[T_ESEMENYTIPUS] WITH CHECK CHECK CONSTRAINT [FK_T_21038_4025716];

ALTER TABLE [dbo].[T_OTPJELENTESTIPUS] WITH CHECK CHECK CONSTRAINT [FK_T_21038_2488607];

ALTER TABLE [dbo].[T_NAPTIPUS] WITH CHECK CHECK CONSTRAINT [FK_T_21038_4025454];

ALTER TABLE [dbo].[T_FENNTARTOTIPUS] WITH CHECK CHECK CONSTRAINT [FK_T_21038_4025245];

ALTER TABLE [dbo].[T_PRIORITAS] WITH CHECK CHECK CONSTRAINT [FK_T_21038_4026956];

ALTER TABLE [dbo].[T_FEETYPE] WITH CHECK CHECK CONSTRAINT [FK_T_21038_283802];

ALTER TABLE [dbo].[T_SZEREPKORTIPUS] WITH CHECK CHECK CONSTRAINT [FK_T_21038_4026190];

ALTER TABLE [dbo].[T_AGAZATTIPUS] WITH CHECK CHECK CONSTRAINT [FK_T_21038_4027554];

ALTER TABLE [dbo].[T_IGAZOLASTIPUS] WITH CHECK CHECK CONSTRAINT [FK_T_21038_4025697];

ALTER TABLE [dbo].[T_KOZTERULETJELLEG] WITH CHECK CHECK CONSTRAINT [FK_T_21038_2425121];

ALTER TABLE [dbo].[T_FOGLALKOZASTIPUS] WITH CHECK CHECK CONSTRAINT [FK_T_21038_4025438];

ALTER TABLE [dbo].[T_CSOPORTTIPUS] WITH CHECK CHECK CONSTRAINT [FK_T_21038_4025243];

ALTER TABLE [dbo].[T_FORRAS] WITH CHECK CHECK CONSTRAINT [FK_T_21038_4026954];

ALTER TABLE [dbo].[T_PAYMENTTITLETYPE] WITH CHECK CHECK CONSTRAINT [FK_T_21038_228252];

ALTER TABLE [dbo].[T_SZAKMACSOPORTTIPUS] WITH CHECK CHECK CONSTRAINT [FK_T_21038_4027553];

ALTER TABLE [dbo].[T_ROKONSAGIFOK] WITH CHECK CHECK CONSTRAINT [FK_T_21038_4025189];

ALTER TABLE [dbo].[T_SZERZODOSZEMELYPOZICIO] WITH CHECK CHECK CONSTRAINT [FK_T_21038_4026714];

ALTER TABLE [dbo].[T_EMAILTIPUS] WITH CHECK CHECK CONSTRAINT [FK_T_21038_48446];

ALTER TABLE [dbo].[T_PARTFILLSTATUS] WITH CHECK CHECK CONSTRAINT [FK_T_21038_4026163];

ALTER TABLE [dbo].[T_SZAKKEPESITESTIPUS] WITH CHECK CHECK CONSTRAINT [FK_T_21038_4027551];

ALTER TABLE [dbo].[T_MULASZTASTIPUS] WITH CHECK CHECK CONSTRAINT [FK_T_21038_4025677];

ALTER TABLE [dbo].[T_ENAPLOTIPUS] WITH CHECK CHECK CONSTRAINT [FK_T_21038_4026713];

ALTER TABLE [dbo].[T_TELEFONTIPUS] WITH CHECK CHECK CONSTRAINT [FK_T_21038_48448];

ALTER TABLE [dbo].[T_MUKODESIHELYTIPUS] WITH CHECK CHECK CONSTRAINT [FK_T_21038_4027517];

ALTER TABLE [dbo].[T_TARGYKATEGORIATIPUS] WITH CHECK CHECK CONSTRAINT [FK_T_21038_4025413];

ALTER TABLE [dbo].[T_ENAPLOFORRAS] WITH CHECK CHECK CONSTRAINT [FK_T_21038_4026712];

ALTER TABLE [dbo].[T_PAYINGTYPE] WITH CHECK CHECK CONSTRAINT [FK_T_21038_48355];

ALTER TABLE [dbo].[T_IKTESZKOZHASZNALATMOD] WITH CHECK CHECK CONSTRAINT [FK_T_21038_4027466];

ALTER TABLE [dbo].[T_STUDENTCARDTYPE] WITH CHECK CHECK CONSTRAINT [FK_T_21038_48470];

ALTER TABLE [dbo].[T_EVFOLYAMTIPUS] WITH CHECK CHECK CONSTRAINT [FK_T_21038_4025414];

ALTER TABLE [dbo].[T_ERTEKELESMOD] WITH CHECK CHECK CONSTRAINT [FK_T_21038_4025675];

ALTER TABLE [dbo].[T_DIAKIGAZOLVANYIGENYSTATUSZ] WITH CHECK CHECK CONSTRAINT [FK_T_21038_2026498];

ALTER TABLE [dbo].[T_ALLAMPOLGARSAG] WITH CHECK CHECK CONSTRAINT [FK_T_21038_48368];

ALTER TABLE [dbo].[T_ELSODLEGESIKTESZKOZ] WITH CHECK CHECK CONSTRAINT [FK_T_21038_4027468];

ALTER TABLE [dbo].[T_OSZTALYZATTIPUS] WITH CHECK CHECK CONSTRAINT [FK_T_21038_4025678];

ALTER TABLE [dbo].[T_SCSTICKERSTATUS] WITH CHECK CHECK CONSTRAINT [FK_T_21038_2026496];

ALTER TABLE [dbo].[T_SYSTEMSETTINGSCONTROLTYPE] WITH CHECK CHECK CONSTRAINT [FK_T_21038_4026110];

ALTER TABLE [dbo].[T_ENAPLOINFRA] WITH CHECK CHECK CONSTRAINT [FK_T_21038_4026711];

ALTER TABLE [dbo].[T_STUDENTCARDSTATUS] WITH CHECK CHECK CONSTRAINT [FK_T_21038_48328];

ALTER TABLE [dbo].[T_ERTESITESTIPUS] WITH CHECK CHECK CONSTRAINT [FK_T_21038_4025883];

ALTER TABLE [dbo].[T_MUNKAKORTIPUS] WITH CHECK CHECK CONSTRAINT [FK_T_21038_4025164];

ALTER TABLE [dbo].[T_ERTEKELESTIPUS] WITH CHECK CHECK CONSTRAINT [FK_T_21038_4025676];

ALTER TABLE [dbo].[T_MUNKAVISZONYJELLEGE] WITH CHECK CHECK CONSTRAINT [FK_T_21038_1931621];

ALTER TABLE [dbo].[T_NATIONALITY] WITH CHECK CHECK CONSTRAINT [FK_T_21038_48367];

ALTER TABLE [dbo].[T_WIFIELERES] WITH CHECK CHECK CONSTRAINT [FK_T_21038_4027469];

ALTER TABLE [dbo].[T_DICTIONARYITEMBASE] WITH CHECK CHECK CONSTRAINT [FK_2103802_2103800];

ALTER TABLE [dbo].[T_DICTIONARYITEMBASE] WITH CHECK CHECK CONSTRAINT [FK_2103805_2103803];


GO
PRINT N'Update complete.';


GO

PRINT '--- intézményi view-k (dbo táblákkal megegyező nevű és a tábla_OSSZES nevűek) frissítése ---'

DECLARE  @viewname nvarchar(100), @pureview nvarchar(100)

DECLARE semaviewk CURSOR LOCAL FOR 
  SELECT '['+TABLE_SCHEMA + '].[' + TABLE_NAME + ']', TABLE_NAME
  FROM INFORMATION_SCHEMA.TABLES
  WHERE TABLE_TYPE = 'VIEW' and TABLE_SCHEMA LIKE 'KR[_]%[_]Schema'
  AND TABLE_NAME in (
  'T_DICTIONARYITEMBASE', 'T_DICTIONARYITEMBASE_OSSZES'
  ) -- ha csak néhány VIEW frissült, akkor a gyorsabb futásért ide fel lehet sorolni
  ORDER BY TABLE_SCHEMA, TABLE_NAME

OPEN semaviewk
FETCH NEXT FROM semaviewk INTO @viewname, @pureview

WHILE @@FETCH_STATUS = 0 BEGIN
	PRINT @viewname
	EXEC sp_refreshview @viewname

    FETCH NEXT FROM semaviewk INTO @viewname, @pureview
END             

CLOSE semaviewk
DEALLOCATE semaviewk
GO
