﻿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].[T_OSSZEFUGGOSZAKGYAK].[I_T_4028381_4028379]...';


GO
DROP INDEX [I_T_4028381_4028379]
    ON [dbo].[T_OSSZEFUGGOSZAKGYAK];


GO
PRINT N'Dropping [dbo].[T_OSSZEFUGGOSZAKGYAK].[UK_4028379]...';


GO
DROP INDEX [UK_4028379]
    ON [dbo].[T_OSSZEFUGGOSZAKGYAK];



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


GO
ALTER TABLE [dbo].[T_OSSZEFUGGOSZAKGYAK] DROP CONSTRAINT [FK_4028372_4028370];


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


GO
ALTER TABLE [dbo].[T_OSSZEFUGGOSZAKGYAK] DROP CONSTRAINT [FK_4028375_4028373];


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


GO
ALTER TABLE [dbo].[T_OSSZEFUGGOSZAKGYAK] DROP CONSTRAINT [FK_4028378_4028376];


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


GO
ALTER TABLE [dbo].[T_OSSZEFUGGOSZAKGYAK] DROP CONSTRAINT [FK_4028381_4028379];


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


GO
ALTER TABLE [dbo].[T_OSSZEFUGGOSZAKGYAK] DROP CONSTRAINT [FK_402836302_402836300];


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


GO
ALTER TABLE [dbo].[T_OSSZEFUGGOSZAKGYAK] DROP CONSTRAINT [FK_402836305_402836303];


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


GO
ALTER TABLE [dbo].[T_NAPLOELLENORZES] DROP CONSTRAINT [FK_4025763_4025762];


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


GO
ALTER TABLE [dbo].[T_OSZTALY] DROP CONSTRAINT [FK_T_4025296_4025338];


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


GO
ALTER TABLE [dbo].[T_OSZTALY] DROP CONSTRAINT [FK_4025320_4025319];


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


GO
ALTER TABLE [dbo].[T_OSZTALY] DROP CONSTRAINT [FK_4025323_4025322];


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


GO
ALTER TABLE [dbo].[T_OSZTALY] DROP CONSTRAINT [FK_4025421_4025419];


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


GO
ALTER TABLE [dbo].[T_OSZTALY] DROP CONSTRAINT [FK_402529402_402529400];


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


GO
ALTER TABLE [dbo].[T_OSZTALY] DROP CONSTRAINT [FK_402529405_402529403];


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


GO
ALTER TABLE [dbo].[T_OSZTALY] DROP CONSTRAINT [FK_4025294_4025295];


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


GO
ALTER TABLE [dbo].[T_OSZTALY] DROP CONSTRAINT [FK_4025294_4027544];


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


GO
ALTER TABLE [dbo].[T_OSZTALY] DROP CONSTRAINT [FK_4025294_4027545];


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


GO
ALTER TABLE [dbo].[T_OSZTALY] DROP CONSTRAINT [FK_4025294_4027546];


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


GO
ALTER TABLE [dbo].[T_OSZTALY] DROP CONSTRAINT [FK_4025294_4027547];


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


GO
ALTER TABLE [dbo].[T_OSZTALY] DROP CONSTRAINT [FK_4025294_4028299];


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


GO
ALTER TABLE [dbo].[T_CSOPORT] DROP CONSTRAINT [FK_4026206_4026204];


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


GO
ALTER TABLE [dbo].[T_CSOPORTOK_OSZTALYOK] DROP CONSTRAINT [FK_4025318_4025316];


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


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


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


GO
ALTER TABLE [dbo].[T_NAPLOELLENORZES] DROP CONSTRAINT [FK_402575205_402575203];


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


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


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


GO
ALTER TABLE [dbo].[T_EMAIL] DROP CONSTRAINT [FK_987605_987603];


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


GO
ALTER TABLE [dbo].[T_TANULOKOZOSSEGISZOLGALAT] DROP CONSTRAINT [FK_402617205_402617203];


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


GO
ALTER TABLE [dbo].[T_SCSTUDENTTEMPORARYCARD] DROP CONSTRAINT [FK_99084705_99084703];


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


GO
ALTER TABLE [dbo].[T_TANULOESEMENYLATTAMOZAS] DROP CONSTRAINT [FK_402804805_402804803];


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


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


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


GO
ALTER TABLE [dbo].[T_KKAMIJAZZZENETIPUS] DROP CONSTRAINT [FK_402838905_402838903];


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


GO
ALTER TABLE [dbo].[T_GONDVISELO] DROP CONSTRAINT [FK_402516905_402516903];


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


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


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


GO
ALTER TABLE [dbo].[T_LOG] DROP CONSTRAINT [FK_402497605_402497603];


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


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


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


GO
ALTER TABLE [dbo].[T_OGTANARFOGLALTSAG] DROP CONSTRAINT [FK_402772405_402772403];


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


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


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


GO
ALTER TABLE [dbo].[T_LOGINNEWS] DROP CONSTRAINT [FK_261034805_261034803];


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


GO
ALTER TABLE [dbo].[T_IGAZOLAS] DROP CONSTRAINT [FK_402574605_402574603];


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


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


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


GO
ALTER TABLE [dbo].[T_CREDITCARDPAYMENT] DROP CONSTRAINT [FK_2294205_2294203];


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


GO
ALTER TABLE [dbo].[T_SCAPPLICATIONFORMBATCH] DROP CONSTRAINT [FK_99079205_99079203];


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


GO
ALTER TABLE [dbo].[T_TANULOMULASZTASLATTAMOZAS] DROP CONSTRAINT [FK_402804605_402804603];


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


GO
ALTER TABLE [dbo].[T_NEMKOTOTTMUNKAIDO] DROP CONSTRAINT [FK_402667705_402667703];


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


GO
ALTER TABLE [dbo].[T_KKTANITOMUVTERTIPUS] DROP CONSTRAINT [FK_402838805_402838803];


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


GO
ALTER TABLE [dbo].[T_FELHASZNALO] DROP CONSTRAINT [FK_893505_893503];


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


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


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


GO
ALTER TABLE [dbo].[T_ERETTSEGIVALASZ] DROP CONSTRAINT [FK_402823405_402823403];


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


GO
ALTER TABLE [dbo].[T_NEBULO] DROP CONSTRAINT [FK_402736305_402736303];


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


GO
ALTER TABLE [dbo].[T_MUKODESIHELYADATSZOLGALTATAS] DROP CONSTRAINT [FK_402771505_402771503];


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


GO
ALTER TABLE [dbo].[T_ORALATOGATAS] DROP CONSTRAINT [FK_402572805_402572803];


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


GO
ALTER TABLE [dbo].[T_JOGYAKORLAT] DROP CONSTRAINT [FK_402590605_402590603];


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


GO
ALTER TABLE [dbo].[T_RENDSZERERTESITESEK] DROP CONSTRAINT [FK_402613705_402613703];


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


GO
ALTER TABLE [dbo].[T_DIAKIGAZOLVANYIGENYLES] DROP CONSTRAINT [FK_99079105_99079103];


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


GO
ALTER TABLE [dbo].[T_ORARENDIORATULAJDONSAG] DROP CONSTRAINT [FK_402799805_402799803];


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


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


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


GO
ALTER TABLE [dbo].[T_CREDITCARDREPLY] DROP CONSTRAINT [FK_2288705_2288703];


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


GO
ALTER TABLE [dbo].[T_ESLADAT] DROP CONSTRAINT [FK_402666905_402666903];


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


GO
ALTER TABLE [dbo].[T_KKAMIKLASSZIKUSTIPUS] DROP CONSTRAINT [FK_402838705_402838703];


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


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


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


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


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


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


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


GO
ALTER TABLE [dbo].[T_TANULOCSOPORT] DROP CONSTRAINT [FK_402551805_402551803];


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


GO
ALTER TABLE [dbo].[T_ERETTSEGIKERDES] DROP CONSTRAINT [FK_402821805_402821803];


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


GO
ALTER TABLE [dbo].[T_INTEZMENYESZKOZADATSZOLGALTA] DROP CONSTRAINT [FK_402767505_402767503];


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


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


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


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


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


GO
ALTER TABLE [dbo].[T_MUNKAUGYIADATOK] DROP CONSTRAINT [FK_402611605_402611603];


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


GO
ALTER TABLE [dbo].[T_ORATULAJDONSAGTIPUS] DROP CONSTRAINT [FK_402797005_402797003];


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


GO
ALTER TABLE [dbo].[T_MUKODESIHELY] DROP CONSTRAINT [FK_402514805_402514803];


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


GO
ALTER TABLE [dbo].[T_SYSTEMPARAMETER] DROP CONSTRAINT [FK_2107905_2107903];


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


GO
ALTER TABLE [dbo].[T_TANULOESLADATOK] DROP CONSTRAINT [FK_402662605_402662603];


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


GO
ALTER TABLE [dbo].[T_SCSTICKER] DROP CONSTRAINT [FK_99079005_99079003];


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


GO
ALTER TABLE [dbo].[T_KKGYOGYPEDTERTIPUS] DROP CONSTRAINT [FK_402838605_402838603];


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


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


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


GO
ALTER TABLE [dbo].[T_OTPJELENTESEK] DROP CONSTRAINT [FK_248900605_248900603];


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


GO
ALTER TABLE [dbo].[T_CIMTARCSOPORT] DROP CONSTRAINT [FK_402546505_402546503];


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


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


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


GO
ALTER TABLE [dbo].[T_LICENCEFUNKCIOKTIPUS] DROP CONSTRAINT [FK_402820405_402820403];


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


GO
ALTER TABLE [dbo].[T_VEZETOIORASZAMOKTIPUS] DROP CONSTRAINT [FK_402763405_402763403];


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


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


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


GO
ALTER TABLE [dbo].[T_TANITASIORATULAJDONSAG] DROP CONSTRAINT [FK_402795405_402795403];


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


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


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


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


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


GO
ALTER TABLE [dbo].[T_KKKEPESITESTIPUS] DROP CONSTRAINT [FK_402838505_402838503];


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


GO
ALTER TABLE [dbo].[T_TANEV] DROP CONSTRAINT [FK_4026254_4026253];


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


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


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


GO
ALTER TABLE [dbo].[T_ALKALMAZOTT] DROP CONSTRAINT [FK_402513905_402513903];


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


GO
ALTER TABLE [dbo].[T_SCINSET] DROP CONSTRAINT [FK_99078905_99078903];


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


GO
ALTER TABLE [dbo].[T_CIMTAR] DROP CONSTRAINT [FK_402546205_402546203];


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


GO
ALTER TABLE [dbo].[T_LICENCE] DROP CONSTRAINT [FK_402820005_402820003];


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


GO
ALTER TABLE [dbo].[T_FOGLALKOZTATASTIPUSA] DROP CONSTRAINT [FK_402762905_402762903];


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


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


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


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


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


GO
ALTER TABLE [dbo].[T_TANULOESEMENY] DROP CONSTRAINT [FK_402569905_402569903];


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


GO
ALTER TABLE [dbo].[T_SCHEDULERTRIGGERS] DROP CONSTRAINT [FK_402589305_402589303];


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


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


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


GO
ALTER TABLE [dbo].[T_NATKERDOIV] DROP CONSTRAINT [FK_402793505_402793503];


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


GO
ALTER TABLE [dbo].[T_FOGLALKOZASARCHIV] DROP CONSTRAINT [FK_402659305_402659303];


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


GO
ALTER TABLE [dbo].[T_KKSZAKTIPUS] DROP CONSTRAINT [FK_402838405_402838403];


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


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


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


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


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


GO
ALTER TABLE [dbo].[T_CSENGETESIREND] DROP CONSTRAINT [FK_402545605_402545603];


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


GO
ALTER TABLE [dbo].[T_ERTMONDATBANKTIPUS] DROP CONSTRAINT [FK_402846405_402846403];


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


GO
ALTER TABLE [dbo].[T_TELEFON] DROP CONSTRAINT [FK_2077505_2077503];


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


GO
ALTER TABLE [dbo].[T_OSZTALYCSOPORT] DROP CONSTRAINT [FK_402529605_402529603];


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


GO
ALTER TABLE [dbo].[T_SCTEMPORARYCARD] DROP CONSTRAINT [FK_99078805_99078803];


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


GO
ALTER TABLE [dbo].[T_ERETTSEGISZINT] DROP CONSTRAINT [FK_402761905_402761903];


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


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


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


GO
ALTER TABLE [dbo].[T_PENZNEMTIPUS] DROP CONSTRAINT [FK_402818705_402818703];


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


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


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


GO
ALTER TABLE [dbo].[T_SCHEDULERCONTEXTS] DROP CONSTRAINT [FK_402588805_402588803];


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


GO
ALTER TABLE [dbo].[T_UPLOADEDFILE] DROP CONSTRAINT [FK_402729805_402729803];


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


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


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


GO
ALTER TABLE [dbo].[T_KKAMIZENEMUVKATTIPUS] DROP CONSTRAINT [FK_402838305_402838303];


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


GO
ALTER TABLE [dbo].[T_ERTEKELESMONDATBANK] DROP CONSTRAINT [FK_402791505_402791503];


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


GO
ALTER TABLE [dbo].[T_SCHEDULERLOG] DROP CONSTRAINT [FK_402608805_402608803];


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


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


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


GO
ALTER TABLE [dbo].[T_PAYMENTTITLE] DROP CONSTRAINT [FK_821405_821403];


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


GO
ALTER TABLE [dbo].[T_KKTANTARGYKATEGORIA] DROP CONSTRAINT [FK_402842805_402842803];


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


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


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


GO
ALTER TABLE [dbo].[T_ERETTSEGITIPUS] DROP CONSTRAINT [FK_402761805_402761803];


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


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


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


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


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


GO
ALTER TABLE [dbo].[T_MEROALLAS] DROP CONSTRAINT [FK_402818405_402818403];


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


GO
ALTER TABLE [dbo].[T_SCCARD] DROP CONSTRAINT [FK_99078705_99078703];


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


GO
ALTER TABLE [dbo].[T_SCHEDULERJOBS] DROP CONSTRAINT [FK_402588505_402588503];


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


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


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


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


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


GO
ALTER TABLE [dbo].[T_CSOPORTTIPUS_FOGLALKOZASTIPU] DROP CONSTRAINT [FK_402653705_402653703];


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


GO
ALTER TABLE [dbo].[T_KOZOSSEGISZOLGALATTIPUS] DROP CONSTRAINT [FK_402791105_402791103];


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


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


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


GO
ALTER TABLE [dbo].[T_BANK] DROP CONSTRAINT [FK_212192505_212192503];


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


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


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


GO
ALTER TABLE [dbo].[T_KKKEPESITESJELLTIPUS] DROP CONSTRAINT [FK_402842705_402842703];


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


GO
ALTER TABLE [dbo].[T_TANEVRENDJE] DROP CONSTRAINT [FK_402544105_402544103];


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


GO
ALTER TABLE [dbo].[T_ERETTSEGIEREDMENY] DROP CONSTRAINT [FK_402760905_402760903];


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


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


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


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


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


GO
ALTER TABLE [dbo].[T_MEROHELYTIPUS] DROP CONSTRAINT [FK_402818305_402818303];


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


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


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


GO
ALTER TABLE [dbo].[T_ERTESITES] DROP CONSTRAINT [FK_402586805_402586803];


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


GO
ALTER TABLE [dbo].[T_EPENZTARCABIZONYLAT] DROP CONSTRAINT [FK_402718905_402718903];


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


GO
ALTER TABLE [dbo].[T_KIRTELEPHELY] DROP CONSTRAINT [FK_402653005_402653003];


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


GO
ALTER TABLE [dbo].[T_OGTEREMFOGLALTSAG] DROP CONSTRAINT [FK_402784705_402784703];


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


GO
ALTER TABLE [dbo].[T_TANULOTARGYMULASZTASSTATISZT] DROP CONSTRAINT [FK_402606805_402606803];


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


GO
ALTER TABLE [dbo].[T_CSENGETESIRENDORA] DROP CONSTRAINT [FK_402567905_402567903];


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


GO
ALTER TABLE [dbo].[T_USERPROFILE] DROP CONSTRAINT [FK_203009405_203009403];


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


GO
ALTER TABLE [dbo].[T_KKJAZZZENE] DROP CONSTRAINT [FK_402842505_402842503];


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


GO
ALTER TABLE [dbo].[T_FORMS] DROP CONSTRAINT [FK_1540405_1540403];


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


GO
ALTER TABLE [dbo].[T_ERETTSEGITANTARGYADATOK] DROP CONSTRAINT [FK_402759905_402759903];


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


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


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


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


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


GO
ALTER TABLE [dbo].[T_KOZMUSZAMLA] DROP CONSTRAINT [FK_402817105_402817103];


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


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


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


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


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


GO
ALTER TABLE [dbo].[T_TRANSACTIONANALYSISFILELINE] DROP CONSTRAINT [FK_813305_813303];


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


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


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


GO
ALTER TABLE [dbo].[T_KIRKONTENERELEMSTATUSZ] DROP CONSTRAINT [FK_402834805_402834803];


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


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


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


GO
ALTER TABLE [dbo].[T_GONDVISELOERTESITES] DROP CONSTRAINT [FK_402586605_402586603];


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


GO
ALTER TABLE [dbo].[T_TANULOMULASZTASSTATISZTIKA] DROP CONSTRAINT [FK_402605305_402605303];


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


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


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


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


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


GO
ALTER TABLE [dbo].[T_OGFOGLALKOZASFOGLALTSAG] DROP CONSTRAINT [FK_402784205_402784203];


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


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


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


GO
ALTER TABLE [dbo].[T_KKKLASSZIKUSZENE] DROP CONSTRAINT [FK_402842305_402842303];


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


GO
ALTER TABLE [dbo].[T_ERETTSEGITANTARGY] DROP CONSTRAINT [FK_402759805_402759803];


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


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


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


GO
ALTER TABLE [dbo].[T_TEREM] DROP CONSTRAINT [FK_402512205_402512203];


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


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


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


GO
ALTER TABLE [dbo].[T_IMPOSITIONSHAREDRULES] DROP CONSTRAINT [FK_1429805_1429803];


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


GO
ALTER TABLE [dbo].[T_EPENZTARCATETEL] DROP CONSTRAINT [FK_402718105_402718103];


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


GO
ALTER TABLE [dbo].[T_TRANSACTIONANALYSISFILE] DROP CONSTRAINT [FK_813005_813003];


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


GO
ALTER TABLE [dbo].[T_BESOROLASIFOKOZATTIPUS] DROP CONSTRAINT [FK_402635305_402635303];


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


GO
ALTER TABLE [dbo].[T_KIRKONTENER] DROP CONSTRAINT [FK_402832105_402832103];


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


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


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


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


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


GO
ALTER TABLE [dbo].[T_OLDALLATOGATOTTSAG] DROP CONSTRAINT [FK_402604205_402604203];


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


GO
ALTER TABLE [dbo].[T_MEROHELY] DROP CONSTRAINT [FK_402816705_402816703];


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


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


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


GO
ALTER TABLE [dbo].[T_TANULOMULASZTAS] DROP CONSTRAINT [FK_402565405_402565403];


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


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


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


GO
ALTER TABLE [dbo].[T_KKAMIVEGZETTSEG] DROP CONSTRAINT [FK_402842105_402842103];


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


GO
ALTER TABLE [dbo].[T_OGEXPORTORAREND] DROP CONSTRAINT [FK_402783805_402783803];


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


GO
ALTER TABLE [dbo].[T_TOVABBIMUNKAUGYIADATOK] DROP CONSTRAINT [FK_402755805_402755803];


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


GO
ALTER TABLE [dbo].[T_SYSTEMPARAMETERVALUE] DROP CONSTRAINT [FK_355895805_355895803];


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


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


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


GO
ALTER TABLE [dbo].[T_IMPOSITION] DROP CONSTRAINT [FK_810805_810803];


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


GO
ALTER TABLE [dbo].[T_INTEZMENYADATSZOLGALTATAS] DROP CONSTRAINT [FK_4026362_4026361];


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


GO
ALTER TABLE [dbo].[T_KIRKONTENERSTATUSZ] DROP CONSTRAINT [FK_402831605_402831603];


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


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


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


GO
ALTER TABLE [dbo].[T_FELHASZNALOERTESITES] DROP CONSTRAINT [FK_402586305_402586303];


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


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


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


GO
ALTER TABLE [dbo].[T_FELADATELLATASIHELY] DROP CONSTRAINT [FK_402601005_402601003];


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


GO
ALTER TABLE [dbo].[T_IMPOSITIONGROUP] DROP CONSTRAINT [FK_1404405_1404403];


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


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


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


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


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


GO
ALTER TABLE [dbo].[T_KOZMUSZAMLATIPUS] DROP CONSTRAINT [FK_402816605_402816603];


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


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


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


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


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


GO
ALTER TABLE [dbo].[T_KKGYOGYPEDVEGZETTSEG] DROP CONSTRAINT [FK_402841905_402841903];


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


GO
ALTER TABLE [dbo].[T_OGORARENDIORA] DROP CONSTRAINT [FK_402783305_402783303];


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


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


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


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


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


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


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


GO
ALTER TABLE [dbo].[T_KIRKONTENERELEM] DROP CONSTRAINT [FK_402831405_402831403];


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


GO
ALTER TABLE [dbo].[T_EPENZTARCAPARAMETEREK] DROP CONSTRAINT [FK_402717105_402717103];


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


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


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


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


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


GO
ALTER TABLE [dbo].[T_KIZAROCSOPORT] DROP CONSTRAINT [FK_402600505_402600503];


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


GO
ALTER TABLE [dbo].[T_CSOPORT] DROP CONSTRAINT [FK_402527705_402527703];


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


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


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


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


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


GO
ALTER TABLE [dbo].[T_FOGLALKOZAS] DROP CONSTRAINT [FK_402542205_402542203];


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


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


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


GO
ALTER TABLE [dbo].[T_KKNEPZENE] DROP CONSTRAINT [FK_402841605_402841603];


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


GO
ALTER TABLE [dbo].[T_OGINTEZMENYFOGLALTSAG] DROP CONSTRAINT [FK_402776105_402776103];


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


GO
ALTER TABLE [dbo].[T_FINANCIALCODE] DROP CONSTRAINT [FK_1331005_1331003];


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


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


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


GO
ALTER TABLE [dbo].[T_FELHASZNALOBELEPESTORTENET] DROP CONSTRAINT [FK_319582805_319582803];


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


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


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


GO
ALTER TABLE [dbo].[T_KIRSZOLGALTATASTIPUS] DROP CONSTRAINT [FK_402831205_402831203];


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


GO
ALTER TABLE [dbo].[T_TEVEKENYSEG] DROP CONSTRAINT [FK_402583905_402583903];


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


GO
ALTER TABLE [dbo].[T_ESZKOZ] DROP CONSTRAINT [FK_402509805_402509803];


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


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


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


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


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


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


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


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


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


GO
ALTER TABLE [dbo].[T_JELSZOVISSZAALLITAS] DROP CONSTRAINT [FK_402814805_402814803];


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


GO
ALTER TABLE [dbo].[T_VPOSCONFIG] DROP CONSTRAINT [FK_163886705_163886703];


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


GO
ALTER TABLE [dbo].[T_KKELEKTROAKUZENE] DROP CONSTRAINT [FK_402841405_402841403];


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


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


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


GO
ALTER TABLE [dbo].[T_HIBAJEGY] DROP CONSTRAINT [FK_402695805_402695803];


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


GO
ALTER TABLE [dbo].[T_OGGENERATORALAP] DROP CONSTRAINT [FK_402775105_402775103];


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


GO
ALTER TABLE [dbo].[T_FEE] DROP CONSTRAINT [FK_1324505_1324503];


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


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


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


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


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


GO
ALTER TABLE [dbo].[T_SZAKTIPUS] DROP CONSTRAINT [FK_402830805_402830803];


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


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


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


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


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


GO
ALTER TABLE [dbo].[T_ORATERVTARGY] DROP CONSTRAINT [FK_402600205_402600203];


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


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


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


GO
ALTER TABLE [dbo].[T_TANULOERTEKELES] DROP CONSTRAINT [FK_402564105_402564103];


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


GO
ALTER TABLE [dbo].[T_HITTANADATSZOLGALTATAS] DROP CONSTRAINT [FK_402813505_402813503];


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


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


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


GO
ALTER TABLE [dbo].[T_KKTERULET] DROP CONSTRAINT [FK_402841205_402841203];


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


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


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


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


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


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


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


GO
ALTER TABLE [dbo].[T_PAYMENTTITLE_ROLES] DROP CONSTRAINT [FK_289347005_289347003];


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


GO
ALTER TABLE [dbo].[T_OGOSZTALYCSOPORTFOGLALTSAG] DROP CONSTRAINT [FK_402774605_402774603];


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


GO
ALTER TABLE [dbo].[T_GIMNAZIUMIEVFOLYAMTIPUS] DROP CONSTRAINT [FK_402830505_402830503];


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


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


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


GO
ALTER TABLE [dbo].[T_FALIUJSAGBEJEGYZES] DROP CONSTRAINT [FK_402581505_402581503];


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


GO
ALTER TABLE [dbo].[T_RENDSZERBEALLITAS] DROP CONSTRAINT [FK_402599705_402599703];


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


GO
ALTER TABLE [dbo].[T_SZEREPKOR] DROP CONSTRAINT [FK_1309205_1309203];


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


GO
ALTER TABLE [dbo].[T_INTEZMENYADATOK] DROP CONSTRAINT [FK_4026244_4026243];


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


GO
ALTER TABLE [dbo].[T_NAPTARIHET] DROP CONSTRAINT [FK_402629405_402629403];


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


GO
ALTER TABLE [dbo].[T_TANITASIORA] DROP CONSTRAINT [FK_402557505_402557503];


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


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


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


GO
ALTER TABLE [dbo].[T_KKTANARVEGZETTSEG] DROP CONSTRAINT [FK_402840905_402840903];


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


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


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


GO
IF OBJECT_ID('dbo.[FK_402813305_402813303]') IS NOT NULL 
	ALTER TABLE [dbo].[T_HITTANTIPUS] DROP CONSTRAINT [FK_402813305_402813303];
GO



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


GO
IF OBJECT_ID('dbo.[FK_402811505_402811503]') IS NOT NULL 
	ALTER TABLE [dbo].[T_HITTANTIPUS] DROP CONSTRAINT [FK_402811505_402811503];


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


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


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


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


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


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


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


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


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


GO
ALTER TABLE [dbo].[T_FALIUJSAGLATOGATTOTSAG] DROP CONSTRAINT [FK_402581305_402581303];


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


GO
ALTER TABLE [dbo].[T_OGFOGLALTSAGTIPUS] DROP CONSTRAINT [FK_402774505_402774503];


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


GO
ALTER TABLE [dbo].[T_ORATERV] DROP CONSTRAINT [FK_402599405_402599403];


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


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


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


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


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


GO
ALTER TABLE [dbo].[T_HELYETTESITESIIDOSZAK] DROP CONSTRAINT [FK_402628605_402628603];


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


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


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


GO
ALTER TABLE [dbo].[T_KKTANITOVEZGETTSEG] DROP CONSTRAINT [FK_402840705_402840703];


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


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


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


GO
ALTER TABLE [dbo].[T_HAZIFELADATOK] DROP CONSTRAINT [FK_402811205_402811203];


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


GO
ALTER TABLE [dbo].[T_TANTARGY] DROP CONSTRAINT [FK_402539905_402539903];


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


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


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


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


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


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


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


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


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


GO
ALTER TABLE [dbo].[T_VEGZETTSEG] DROP CONSTRAINT [FK_402828705_402828703];


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


GO
ALTER TABLE [dbo].[T_PEDAGOGUSELETPALYAMODELL] DROP CONSTRAINT [FK_402580105_402580103];


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


GO
ALTER TABLE [dbo].[T_OGFOGLALKOZAS] DROP CONSTRAINT [FK_402774105_402774103];


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


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


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


GO
ALTER TABLE [dbo].[T_CIM] DROP CONSTRAINT [FK_1109405_1109403];


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


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


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


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


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


GO
ALTER TABLE [dbo].[T_KKVEGZETTSEGTIPUS] DROP CONSTRAINT [FK_402839405_402839403];


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


GO
ALTER TABLE [dbo].[T_VEGZETTSEGTIPUS] DROP CONSTRAINT [FK_402810805_402810803];


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


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


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


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


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


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


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


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


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


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


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


GO
ALTER TABLE [dbo].[T_TANULOHAZIFELADAT] DROP CONSTRAINT [FK_402827105_402827103];


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


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


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


GO
ALTER TABLE [dbo].[T_OGTANTARGYFOGLALTSAG] DROP CONSTRAINT [FK_402773605_402773603];


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


GO
ALTER TABLE [dbo].[T_FELHASZNALOERTESITESBEALLITA] DROP CONSTRAINT [FK_402596205_402596203];


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


GO
ALTER TABLE [dbo].[T_TRANSACTION] DROP CONSTRAINT [FK_1073505_1073503];


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


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


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


GO
ALTER TABLE [dbo].[T_TANTERV] DROP CONSTRAINT [FK_402539205_402539203];


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


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


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


GO
ALTER TABLE [dbo].[T_KKAMINEPZENETIPUS] DROP CONSTRAINT [FK_402839305_402839303];


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


GO
ALTER TABLE [dbo].[T_ENTITYATTRIBUTEHISTORY] DROP CONSTRAINT [FK_402508005_402508003];


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


GO
ALTER TABLE [dbo].[T_ELEARNING] DROP CONSTRAINT [FK_402809805_402809803];


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


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


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


GO
ALTER TABLE [dbo].[T_IMPOSITIONIMPOSITIONGROUP] DROP CONSTRAINT [FK_276170205_276170203];


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


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


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


GO
ALTER TABLE [dbo].[T_NAPTARINAP] DROP CONSTRAINT [FK_402556205_402556203];


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


GO
ALTER TABLE [dbo].[T_PEDAGOGUSIKTADATSZOLGALTATAS] DROP CONSTRAINT [FK_402742405_402742403];


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


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


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


GO
ALTER TABLE [dbo].[T_TANARIATLAGSULY] DROP CONSTRAINT [FK_402595705_402595703];


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


GO
ALTER TABLE [dbo].[T_IKTATOTTDOKUMENTUMOK] DROP CONSTRAINT [FK_402621205_402621203];


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


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


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


GO
ALTER TABLE [dbo].[T_OGFOGLALKOZAS_TEREM] DROP CONSTRAINT [FK_402773405_402773403];


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


GO
ALTER TABLE [dbo].[T_TANULO] DROP CONSTRAINT [FK_4026237_4026236];


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


GO
ALTER TABLE [dbo].[T_TANULO] DROP CONSTRAINT [FK_402517805_402517803];


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


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


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


GO
ALTER TABLE [dbo].[T_KKAMIELEKTROAKUTIPUS] DROP CONSTRAINT [FK_402839205_402839203];


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


GO
ALTER TABLE [dbo].[T_ENTITYHISTORY] DROP CONSTRAINT [FK_402504305_402504303];


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


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


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


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


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


GO
ALTER TABLE [dbo].[T_PARTNER] DROP CONSTRAINT [FK_1068505_1068503];


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


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


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


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


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


GO
ALTER TABLE [dbo].[T_DICTIONARYTYPE] DROP CONSTRAINT [FK_402808305_402808303];


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


GO
ALTER TABLE [dbo].[T_TANMENET] DROP CONSTRAINT [FK_402555605_402555603];


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


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


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


GO
ALTER TABLE [dbo].[T_TANARITANTARGY] DROP CONSTRAINT [FK_402594005_402594003];


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


GO
ALTER TABLE [dbo].[T_JOGOSULTSAG] DROP CONSTRAINT [FK_402619105_402619103];


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


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


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


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


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


GO
ALTER TABLE [dbo].[T_KKAMIVEGZETTSEGTIPUS] DROP CONSTRAINT [FK_402839105_402839103];


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


GO
ALTER TABLE [dbo].[T_OGOSZTALYCSOPORT] DROP CONSTRAINT [FK_402773005_402773003];


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


GO
ALTER TABLE [dbo].[T_FELHASZNALOBELEPES] DROP CONSTRAINT [FK_402502205_402502203];


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


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


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


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


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


GO
ALTER TABLE [dbo].[T_ONLINEUSER] DROP CONSTRAINT [FK_265686405_265686403];


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


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


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


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


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


GO
ALTER TABLE [dbo].[T_ORARENDIORA] DROP CONSTRAINT [FK_402553005_402553003];


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


GO
ALTER TABLE [dbo].[T_TANULOMENTESSEG] DROP CONSTRAINT [FK_402576905_402576903];


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


GO
ALTER TABLE [dbo].[T_ERTESITESGENERALASTORTENET] DROP CONSTRAINT [FK_402592805_402592803];


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


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


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


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


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


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


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


GO
ALTER TABLE [dbo].[T_TANULOERTEKELESLATTAMOZAS] DROP CONSTRAINT [FK_402805005_402805003];


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


GO
ALTER TABLE [dbo].[T_ADATSZOLGALTATASENAPLO] DROP CONSTRAINT [FK_402669405_402669403];


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


GO
ALTER TABLE [dbo].[T_KKAMITERULETTIPUS] DROP CONSTRAINT [FK_402839005_402839003];


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


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


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


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


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


GO
ALTER TABLE [dbo].[T_LOGINLINKS] DROP CONSTRAINT [FK_261224905_261224903];


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


GO
ALTER TABLE [dbo].[T_BANKACCOUNT] DROP CONSTRAINT [FK_2552905_2552903];


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


GO
ALTER TABLE [dbo].[T_OGTEREM_TANTARGY] DROP CONSTRAINT [FK_402772905_402772903];


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


GO
ALTER TABLE [dbo].[T_TANULOERTEKELES] DROP CONSTRAINT [FK_402564102_402564100];


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


GO
ALTER TABLE [dbo].[T_TANULOERTEKELES] DROP CONSTRAINT [FK_4025641_4025644];


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


GO
ALTER TABLE [dbo].[T_TANULOERTEKELES] DROP CONSTRAINT [FK_4025641_4026317];


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


GO
ALTER TABLE [dbo].[T_TANULOERTEKELES] DROP CONSTRAINT [FK_4025641_4028206];


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


GO
ALTER TABLE [dbo].[T_TANULOERTEKELES] DROP CONSTRAINT [FK_4025641_4028210];


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


GO
ALTER TABLE [dbo].[T_TANULOERTEKELES] DROP CONSTRAINT [FK_4025641_4028211];


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


GO
ALTER TABLE [dbo].[T_TANULOERTEKELES] DROP CONSTRAINT [FK_4025641_4028214];


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


GO
ALTER TABLE [dbo].[T_TANULOERTEKELES] DROP CONSTRAINT [FK_4025641_4028215];


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


GO
ALTER TABLE [dbo].[T_TANULOERTEKELES] DROP CONSTRAINT [FK_4025662_4025660];


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


GO
ALTER TABLE [dbo].[T_TANULOERTEKELES] DROP CONSTRAINT [FK_4025665_4025663];


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


GO
ALTER TABLE [dbo].[T_TANULOERTEKELES] DROP CONSTRAINT [FK_4025668_4025666];


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


GO
ALTER TABLE [dbo].[T_TANULOERTEKELES] DROP CONSTRAINT [FK_4025670_4025669];


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


GO
ALTER TABLE [dbo].[T_TANULOERTEKELES] DROP CONSTRAINT [FK_4025938_4025937];


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


GO
ALTER TABLE [dbo].[T_TANULOERTEKELES] DROP CONSTRAINT [FK_4028462_4028461];


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


GO
ALTER TABLE [dbo].[T_TANULOERTEKELESLATTAMOZAS] DROP CONSTRAINT [FK_4028054_4028052];


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


GO
BEGIN TRANSACTION;

SET TRANSACTION ISOLATION LEVEL SERIALIZABLE;

SET XACT_ABORT ON;

CREATE TABLE [dbo].[tmp_ms_xx_T_OSSZEFUGGOSZAKGYAK] (
    [ID]                  INT            IDENTITY (1, 1) NOT NULL,
    [C_MEGJEGYZES]        NVARCHAR (MAX) NULL,
    [C_TELJESITETT]       CHAR (1)       NULL,
    [C_TELJESITESDATUM]   DATETIME       NULL,
    [C_TANTARGYID]        INT            NOT NULL,
    [C_TANULOID]          INT            NOT NULL,
    [C_CSOPORTID]         INT            NOT NULL,
    [C_INTEZMENYID]       INT            NOT NULL,
    [C_TANEVID]           INT            NOT NULL,
    [TOROLT]              CHAR (1)       DEFAULT ('F') NOT NULL,
    [SERIAL]              INT            DEFAULT ((0)) NOT NULL,
    [LASTCHANGED]         DATETIME       DEFAULT (getdate()) NOT NULL,
    [CREATED]             DATETIME       DEFAULT (getdate()) NOT NULL,
    [MODIFIER]            INT            NULL,
    [CREATOR]             INT            NULL,
    [ELOZOTANEVIREKORDID] INT            NULL,
    [NNID]                INT            NULL,
    CONSTRAINT [tmp_ms_xx_constraint_PK_T_40283631] PRIMARY KEY CLUSTERED ([ID] ASC)
);

IF EXISTS (SELECT TOP 1 1 
           FROM   [dbo].[T_OSSZEFUGGOSZAKGYAK])
    BEGIN
        SET IDENTITY_INSERT [dbo].[tmp_ms_xx_T_OSSZEFUGGOSZAKGYAK] ON;
        INSERT INTO [dbo].[tmp_ms_xx_T_OSSZEFUGGOSZAKGYAK] ([ID], [C_MEGJEGYZES], [C_TELJESITETT], [C_TANTARGYID], [C_TANULOID], [C_CSOPORTID], [C_INTEZMENYID], [C_TANEVID], [TOROLT], [SERIAL], [LASTCHANGED], [CREATED], [MODIFIER], [CREATOR], [ELOZOTANEVIREKORDID], [NNID])
        SELECT   [ID],
                 [C_MEGJEGYZES],
                 [C_TELJESITETT],
                 [C_TANTARGYID],
                 [C_TANULOID],
                 [C_CSOPORTID],
                 [C_INTEZMENYID],
                 [C_TANEVID],
                 [TOROLT],
                 [SERIAL],
                 [LASTCHANGED],
                 [CREATED],
                 [MODIFIER],
                 [CREATOR],
                 [ELOZOTANEVIREKORDID],
                 [NNID]
        FROM     [dbo].[T_OSSZEFUGGOSZAKGYAK]
        ORDER BY [ID] ASC;
        SET IDENTITY_INSERT [dbo].[tmp_ms_xx_T_OSSZEFUGGOSZAKGYAK] OFF;
    END

DROP TABLE [dbo].[T_OSSZEFUGGOSZAKGYAK];

EXECUTE sp_rename N'[dbo].[tmp_ms_xx_T_OSSZEFUGGOSZAKGYAK]', N'T_OSSZEFUGGOSZAKGYAK';

EXECUTE sp_rename N'[dbo].[tmp_ms_xx_constraint_PK_T_40283631]', N'PK_T_4028363', N'OBJECT';

COMMIT TRANSACTION;

SET TRANSACTION ISOLATION LEVEL READ COMMITTED;


GO
PRINT N'Creating [dbo].[T_OSSZEFUGGOSZAKGYAK].[I_T_4028372_4028370]...';


GO
CREATE NONCLUSTERED INDEX [I_T_4028372_4028370]
    ON [dbo].[T_OSSZEFUGGOSZAKGYAK]([C_TANTARGYID] ASC);


GO
PRINT N'Creating [dbo].[T_OSSZEFUGGOSZAKGYAK].[I_T_4028375_4028373]...';


GO
CREATE NONCLUSTERED INDEX [I_T_4028375_4028373]
    ON [dbo].[T_OSSZEFUGGOSZAKGYAK]([C_TANULOID] ASC);


GO
PRINT N'Creating [dbo].[T_OSSZEFUGGOSZAKGYAK].[I_T_4028378_4028376]...';


GO
CREATE NONCLUSTERED INDEX [I_T_4028378_4028376]
    ON [dbo].[T_OSSZEFUGGOSZAKGYAK]([C_CSOPORTID] ASC);


GO
PRINT N'Creating [dbo].[T_OSSZEFUGGOSZAKGYAK].[I_T_402836302_402836300]...';


GO
CREATE NONCLUSTERED INDEX [I_T_402836302_402836300]
    ON [dbo].[T_OSSZEFUGGOSZAKGYAK]([C_INTEZMENYID] ASC);


GO
PRINT N'Creating [dbo].[T_OSSZEFUGGOSZAKGYAK].[I_T_402836305_402836303]...';


GO
CREATE NONCLUSTERED INDEX [I_T_402836305_402836303]
    ON [dbo].[T_OSSZEFUGGOSZAKGYAK]([C_TANEVID] ASC);


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


GO
BEGIN TRANSACTION;

SET TRANSACTION ISOLATION LEVEL SERIALIZABLE;

SET XACT_ABORT ON;

CREATE TABLE [dbo].[tmp_ms_xx_T_OSZTALY] (
    [ID]                          INT            NOT NULL,
    [C_KEPZESIFORMA]              INT            NOT NULL,
    [C_OSZTALYNAPLOLEIRASA]       NVARCHAR (MAX) NULL,
    [C_OSZTALYNAPLOMEGNYITASA]    DATETIME       NULL,
    [C_OSZTALYNAPLOZARASA]        DATETIME       NULL,
    [C_AGAZAT]                    INT            NULL,
    [C_RESZSZAKKEPESITES]         INT            NULL,
    [C_SZAKKEPESITES]             INT            NULL,
    [C_SZAKMACSOPORT]             INT            NULL,
    [C_TECHNIKAIOSZTALY]          CHAR (1)       DEFAULT ('F') NOT NULL,
    [C_GIMNAZIUMIEVFOLYAMTIPUSID] INT            NULL,
    [C_GYOGYPEDAGOGIAI]           CHAR (1)       DEFAULT ('F') NOT NULL,
    [C_KETTANNYELVU]              CHAR (1)       DEFAULT ('F') NOT NULL,
    [C_LOGOPEDIAI]                CHAR (1)       DEFAULT ('F') NOT NULL,
    [C_NEMZETISEGI]               CHAR (1)       DEFAULT ('F') NOT NULL,
    [C_NYELVIELOKESZITO]          CHAR (1)       DEFAULT ('F') NOT NULL,
    [C_SPORT]                     CHAR (1)       DEFAULT ('F') NOT NULL,
    [C_AJTEHETTSEGGONDOZOPROGRAM] CHAR (1)       DEFAULT ('F') NOT NULL,
    [C_OSZTALYFONOKID]            INT            NULL,
    [C_OFOHELYETTESID]            INT            NULL,
    [C_TANTERVID]                 INT            NULL,
    [C_ALINTEZMENYID]             INT            NOT NULL,
    [C_ALTANEVID]                 INT            NOT NULL,
    [TOROLT]                      CHAR (1)       DEFAULT ('F') NOT NULL,
    [SERIAL]                      INT            DEFAULT ((0)) NOT NULL,
    [LASTCHANGED]                 DATETIME       DEFAULT (getdate()) NOT NULL,
    [CREATED]                     DATETIME       DEFAULT (getdate()) NOT NULL,
    [MODIFIER]                    INT            NULL,
    [CREATOR]                     INT            NULL,
    [ELOZOTANEVIREKORDID]         INT            NULL,
    [ELOZOTANEVIREKORDIDA]        INT            NULL,
    [NNID]                        INT            NULL,
    CONSTRAINT [tmp_ms_xx_constraint_PK_T_40252941] PRIMARY KEY CLUSTERED ([ID] ASC)
);

IF EXISTS (SELECT TOP 1 1 
           FROM   [dbo].[T_OSZTALY])
    BEGIN
        INSERT INTO [dbo].[tmp_ms_xx_T_OSZTALY] ([ID], [C_KEPZESIFORMA], [C_OSZTALYNAPLOLEIRASA], [C_OSZTALYNAPLOMEGNYITASA], [C_OSZTALYNAPLOZARASA], [C_AGAZAT], [C_RESZSZAKKEPESITES], [C_SZAKKEPESITES], [C_SZAKMACSOPORT], [C_TECHNIKAIOSZTALY], [C_GIMNAZIUMIEVFOLYAMTIPUSID], [C_GYOGYPEDAGOGIAI], [C_KETTANNYELVU], [C_LOGOPEDIAI], [C_NEMZETISEGI], [C_NYELVIELOKESZITO], [C_SPORT], [C_OSZTALYFONOKID], [C_OFOHELYETTESID], [C_TANTERVID], [C_ALINTEZMENYID], [C_ALTANEVID], [TOROLT], [SERIAL], [LASTCHANGED], [CREATED], [MODIFIER], [CREATOR], [ELOZOTANEVIREKORDID], [ELOZOTANEVIREKORDIDA], [NNID])
        SELECT   [ID],
                 [C_KEPZESIFORMA],
                 [C_OSZTALYNAPLOLEIRASA],
                 [C_OSZTALYNAPLOMEGNYITASA],
                 [C_OSZTALYNAPLOZARASA],
                 [C_AGAZAT],
                 [C_RESZSZAKKEPESITES],
                 [C_SZAKKEPESITES],
                 [C_SZAKMACSOPORT],
                 [C_TECHNIKAIOSZTALY],
                 [C_GIMNAZIUMIEVFOLYAMTIPUSID],
                 [C_GYOGYPEDAGOGIAI],
                 [C_KETTANNYELVU],
                 [C_LOGOPEDIAI],
                 [C_NEMZETISEGI],
                 [C_NYELVIELOKESZITO],
                 [C_SPORT],
                 [C_OSZTALYFONOKID],
                 [C_OFOHELYETTESID],
                 [C_TANTERVID],
                 [C_ALINTEZMENYID],
                 [C_ALTANEVID],
                 [TOROLT],
                 [SERIAL],
                 [LASTCHANGED],
                 [CREATED],
                 [MODIFIER],
                 [CREATOR],
                 [ELOZOTANEVIREKORDID],
                 [ELOZOTANEVIREKORDIDA],
                 [NNID]
        FROM     [dbo].[T_OSZTALY]
        ORDER BY [ID] ASC;
    END

DROP TABLE [dbo].[T_OSZTALY];

EXECUTE sp_rename N'[dbo].[tmp_ms_xx_T_OSZTALY]', N'T_OSZTALY';

EXECUTE sp_rename N'[dbo].[tmp_ms_xx_constraint_PK_T_40252941]', N'PK_T_4025294', N'OBJECT';

COMMIT TRANSACTION;

SET TRANSACTION ISOLATION LEVEL READ COMMITTED;


GO
PRINT N'Creating [dbo].[T_OSZTALY].[I_T_4025294_4025295]...';


GO
CREATE NONCLUSTERED INDEX [I_T_4025294_4025295]
    ON [dbo].[T_OSZTALY]([C_ALINTEZMENYID] ASC, [C_ALTANEVID] ASC, [C_KEPZESIFORMA] ASC);


GO
PRINT N'Creating [dbo].[T_OSZTALY].[I_T_4025294_4027544]...';


GO
CREATE NONCLUSTERED INDEX [I_T_4025294_4027544]
    ON [dbo].[T_OSZTALY]([C_ALINTEZMENYID] ASC, [C_ALTANEVID] ASC, [C_AGAZAT] ASC);


GO
PRINT N'Creating [dbo].[T_OSZTALY].[I_T_4025294_4027545]...';


GO
CREATE NONCLUSTERED INDEX [I_T_4025294_4027545]
    ON [dbo].[T_OSZTALY]([C_ALINTEZMENYID] ASC, [C_ALTANEVID] ASC, [C_RESZSZAKKEPESITES] ASC);


GO
PRINT N'Creating [dbo].[T_OSZTALY].[I_T_4025294_4027546]...';


GO
CREATE NONCLUSTERED INDEX [I_T_4025294_4027546]
    ON [dbo].[T_OSZTALY]([C_ALINTEZMENYID] ASC, [C_ALTANEVID] ASC, [C_SZAKKEPESITES] ASC);


GO
PRINT N'Creating [dbo].[T_OSZTALY].[I_T_4025294_4027547]...';


GO
CREATE NONCLUSTERED INDEX [I_T_4025294_4027547]
    ON [dbo].[T_OSZTALY]([C_ALINTEZMENYID] ASC, [C_ALTANEVID] ASC, [C_SZAKMACSOPORT] ASC);


GO
PRINT N'Creating [dbo].[T_OSZTALY].[I_T_4025294_4028299]...';


GO
CREATE NONCLUSTERED INDEX [I_T_4025294_4028299]
    ON [dbo].[T_OSZTALY]([C_ALINTEZMENYID] ASC, [C_ALTANEVID] ASC, [C_GIMNAZIUMIEVFOLYAMTIPUSID] ASC);


GO
PRINT N'Creating [dbo].[T_OSZTALY].[I_T_4025320_4025319]...';


GO
CREATE NONCLUSTERED INDEX [I_T_4025320_4025319]
    ON [dbo].[T_OSZTALY]([C_OSZTALYFONOKID] ASC);


GO
PRINT N'Creating [dbo].[T_OSZTALY].[I_T_4025323_4025322]...';


GO
CREATE NONCLUSTERED INDEX [I_T_4025323_4025322]
    ON [dbo].[T_OSZTALY]([C_OFOHELYETTESID] ASC);


GO
PRINT N'Creating [dbo].[T_OSZTALY].[I_T_4025421_4025419]...';


GO
CREATE NONCLUSTERED INDEX [I_T_4025421_4025419]
    ON [dbo].[T_OSZTALY]([C_TANTERVID] ASC);


GO
PRINT N'Creating [dbo].[T_OSZTALY].[I_T_402529402_402529400]...';


GO
CREATE NONCLUSTERED INDEX [I_T_402529402_402529400]
    ON [dbo].[T_OSZTALY]([C_ALINTEZMENYID] ASC);


GO
PRINT N'Creating [dbo].[T_OSZTALY].[I_T_402529405_402529403]...';


GO
CREATE NONCLUSTERED INDEX [I_T_402529405_402529403]
    ON [dbo].[T_OSZTALY]([C_ALTANEVID] ASC);


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


GO
BEGIN TRANSACTION;

SET TRANSACTION ISOLATION LEVEL SERIALIZABLE;

SET XACT_ABORT ON;

CREATE TABLE [dbo].[tmp_ms_xx_T_TANEV] (
    [ID]                  INT           IDENTITY (1, 1) NOT NULL,
    [C_AKTIV]             CHAR (1)      DEFAULT ('F') NULL,
    [C_ELSOTANITASINAP]   DATETIME      NULL,
    [C_KEZDONAP]          DATETIME      NULL,
    [C_KOVETKEZO]         CHAR (1)      DEFAULT ('F') NULL,
    [C_NEV]               NVARCHAR (20) NULL,
    [C_SORSZAM]           INT           NULL,
    [C_UTOLSONAP]         DATETIME      NULL,
    [C_UTOLSOTANITASINAP] DATETIME      NULL,
    [C_AKTIVALVA]         DATETIME      NULL,
    [C_INTEZMENYID]       INT           NOT NULL,
    [TOROLT]              CHAR (1)      DEFAULT ('F') NOT NULL,
    [SERIAL]              INT           DEFAULT ((0)) NOT NULL,
    [LASTCHANGED]         DATETIME      DEFAULT (getdate()) NOT NULL,
    [CREATED]             DATETIME      DEFAULT (getdate()) NOT NULL,
    [MODIFIER]            INT           NULL,
    [CREATOR]             INT           NULL,
    [ELOZOTANEVIREKORDID] INT           NULL,
    [NNID]                INT           NULL,
    CONSTRAINT [tmp_ms_xx_constraint_PK_T_40253011] PRIMARY KEY CLUSTERED ([ID] ASC)
);

IF EXISTS (SELECT TOP 1 1 
           FROM   [dbo].[T_TANEV])
    BEGIN
        SET IDENTITY_INSERT [dbo].[tmp_ms_xx_T_TANEV] ON;
        INSERT INTO [dbo].[tmp_ms_xx_T_TANEV] ([ID], [C_AKTIV], [C_ELSOTANITASINAP], [C_KEZDONAP], [C_KOVETKEZO], [C_NEV], [C_SORSZAM], [C_UTOLSONAP], [C_UTOLSOTANITASINAP], [C_INTEZMENYID], [TOROLT], [SERIAL], [LASTCHANGED], [CREATED], [MODIFIER], [CREATOR], [ELOZOTANEVIREKORDID], [NNID])
        SELECT   [ID],
                 [C_AKTIV],
                 [C_ELSOTANITASINAP],
                 [C_KEZDONAP],
                 [C_KOVETKEZO],
                 [C_NEV],
                 [C_SORSZAM],
                 [C_UTOLSONAP],
                 [C_UTOLSOTANITASINAP],
                 [C_INTEZMENYID],
                 [TOROLT],
                 [SERIAL],
                 [LASTCHANGED],
                 [CREATED],
                 [MODIFIER],
                 [CREATOR],
                 [ELOZOTANEVIREKORDID],
                 [NNID]
        FROM     [dbo].[T_TANEV]
        ORDER BY [ID] ASC;
        SET IDENTITY_INSERT [dbo].[tmp_ms_xx_T_TANEV] OFF;
    END

DROP TABLE [dbo].[T_TANEV];

EXECUTE sp_rename N'[dbo].[tmp_ms_xx_T_TANEV]', N'T_TANEV';

EXECUTE sp_rename N'[dbo].[tmp_ms_xx_constraint_PK_T_40253011]', N'PK_T_4025301', N'OBJECT';

COMMIT TRANSACTION;

SET TRANSACTION ISOLATION LEVEL READ COMMITTED;


GO
PRINT N'Creating [dbo].[T_TANEV].[I_T_4026254_4026253]...';


GO
CREATE NONCLUSTERED INDEX [I_T_4026254_4026253]
    ON [dbo].[T_TANEV]([C_INTEZMENYID] ASC);


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


GO
BEGIN TRANSACTION;

SET TRANSACTION ISOLATION LEVEL SERIALIZABLE;

SET XACT_ABORT ON;

CREATE TABLE [dbo].[tmp_ms_xx_T_TANULOERTEKELES] (
    [ID]                            INT            IDENTITY (1, 1) NOT NULL,
    [C_DATUM]                       DATETIME       NOT NULL,
    [C_TIPUSID]                     INT            NOT NULL,
    [C_ERTEKELESSZOVEG]             NVARCHAR (MAX) NULL,
    [C_ROGZITESDATUM]               DATETIME       NOT NULL,
    [C_ERTEKELESOSZTALYZATID]       INT            NULL,
    [C_ERTEKELESSZOVEGROVIDNEV]     NVARCHAR (3)   NULL,
    [C_ERTEKELESMODID]              INT            NULL,
    [C_ERTEKELESTEMA]               NVARCHAR (255) NULL,
    [C_ERTEKELESSZAZALEK]           INT            NULL,
    [C_ISMAGATARTASSZORGALOM]       CHAR (1)       NOT NULL,
    [C_MAGATARTASERTEKID]           INT            NULL,
    [C_MAGATARTASOSZTALYZATID]      INT            NULL,
    [C_MAGATARTASSZOVEG]            NVARCHAR (MAX) NULL,
    [C_MAGATARTASSZOVEGROVIDNEV]    NVARCHAR (3)   NULL,
    [C_SZORGALOMERTEKID]            INT            NULL,
    [C_SZORGALOMOSZTALYZATID]       INT            NULL,
    [C_SZORGALOMSZOVEG]             NVARCHAR (MAX) NULL,
    [C_SZORGALOMSZOVEGROVIDNEV]     NVARCHAR (3)   NULL,
    [C_TANTARGYID]                  INT            NULL,
    [C_TANULOID]                    INT            NOT NULL,
    [C_OSZTALYCSOPORTID]            INT            NULL,
    [C_ERTEKELOID]                  INT            NOT NULL,
    [C_TANORAID]                    INT            NULL,
    [C_OSSZEFUGGOSZAKGYAKID]        INT            NULL,
    [C_ROGZITESKORITANULOOSZTALYID] INT            NULL,
    [C_INTEZMENYID]                 INT            NOT NULL,
    [C_TANEVID]                     INT            NOT NULL,
    [TOROLT]                        CHAR (1)       DEFAULT ('F') NOT NULL,
    [SERIAL]                        INT            DEFAULT ((0)) NOT NULL,
    [LASTCHANGED]                   DATETIME       DEFAULT (getdate()) NOT NULL,
    [CREATED]                       DATETIME       DEFAULT (getdate()) NOT NULL,
    [MODIFIER]                      INT            NULL,
    [CREATOR]                       INT            NULL,
    [ELOZOTANEVIREKORDID]           INT            NULL,
    [NNID]                          INT            NULL,
    CONSTRAINT [tmp_ms_xx_constraint_PK_T_40256411] PRIMARY KEY CLUSTERED ([ID] ASC)
);

IF EXISTS (SELECT TOP 1 1 
           FROM   [dbo].[T_TANULOERTEKELES])
    BEGIN
        SET IDENTITY_INSERT [dbo].[tmp_ms_xx_T_TANULOERTEKELES] ON;
        INSERT INTO [dbo].[tmp_ms_xx_T_TANULOERTEKELES] ([ID], [C_DATUM], [C_TIPUSID], [C_ERTEKELESSZOVEG], [C_ROGZITESDATUM], [C_ERTEKELESOSZTALYZATID], [C_ERTEKELESSZOVEGROVIDNEV], [C_ERTEKELESMODID], [C_ERTEKELESTEMA], [C_ERTEKELESSZAZALEK], [C_ISMAGATARTASSZORGALOM], [C_MAGATARTASERTEKID], [C_MAGATARTASOSZTALYZATID], [C_MAGATARTASSZOVEG], [C_MAGATARTASSZOVEGROVIDNEV], [C_SZORGALOMERTEKID], [C_SZORGALOMOSZTALYZATID], [C_SZORGALOMSZOVEG], [C_SZORGALOMSZOVEGROVIDNEV], [C_TANTARGYID], [C_TANULOID], [C_OSZTALYCSOPORTID], [C_ERTEKELOID], [C_TANORAID], [C_ROGZITESKORITANULOOSZTALYID], [C_INTEZMENYID], [C_TANEVID], [TOROLT], [SERIAL], [LASTCHANGED], [CREATED], [MODIFIER], [CREATOR], [ELOZOTANEVIREKORDID], [NNID])
        SELECT   [ID],
                 [C_DATUM],
                 [C_TIPUSID],
                 [C_ERTEKELESSZOVEG],
                 [C_ROGZITESDATUM],
                 [C_ERTEKELESOSZTALYZATID],
                 [C_ERTEKELESSZOVEGROVIDNEV],
                 [C_ERTEKELESMODID],
                 [C_ERTEKELESTEMA],
                 [C_ERTEKELESSZAZALEK],
                 [C_ISMAGATARTASSZORGALOM],
                 [C_MAGATARTASERTEKID],
                 [C_MAGATARTASOSZTALYZATID],
                 [C_MAGATARTASSZOVEG],
                 [C_MAGATARTASSZOVEGROVIDNEV],
                 [C_SZORGALOMERTEKID],
                 [C_SZORGALOMOSZTALYZATID],
                 [C_SZORGALOMSZOVEG],
                 [C_SZORGALOMSZOVEGROVIDNEV],
                 [C_TANTARGYID],
                 [C_TANULOID],
                 [C_OSZTALYCSOPORTID],
                 [C_ERTEKELOID],
                 [C_TANORAID],
                 [C_ROGZITESKORITANULOOSZTALYID],
                 [C_INTEZMENYID],
                 [C_TANEVID],
                 [TOROLT],
                 [SERIAL],
                 [LASTCHANGED],
                 [CREATED],
                 [MODIFIER],
                 [CREATOR],
                 [ELOZOTANEVIREKORDID],
                 [NNID]
        FROM     [dbo].[T_TANULOERTEKELES]
        ORDER BY [ID] ASC;
        SET IDENTITY_INSERT [dbo].[tmp_ms_xx_T_TANULOERTEKELES] OFF;
    END

DROP TABLE [dbo].[T_TANULOERTEKELES];

EXECUTE sp_rename N'[dbo].[tmp_ms_xx_T_TANULOERTEKELES]', N'T_TANULOERTEKELES';

EXECUTE sp_rename N'[dbo].[tmp_ms_xx_constraint_PK_T_40256411]', N'PK_T_4025641', N'OBJECT';

COMMIT TRANSACTION;

SET TRANSACTION ISOLATION LEVEL READ COMMITTED;


GO
PRINT N'Creating [dbo].[T_TANULOERTEKELES].[I_T_4025641_4025644]...';


GO
CREATE NONCLUSTERED INDEX [I_T_4025641_4025644]
    ON [dbo].[T_TANULOERTEKELES]([C_INTEZMENYID] ASC, [C_TANEVID] ASC, [C_TIPUSID] ASC);


GO
PRINT N'Creating [dbo].[T_TANULOERTEKELES].[I_T_4025641_4026317]...';


GO
CREATE NONCLUSTERED INDEX [I_T_4025641_4026317]
    ON [dbo].[T_TANULOERTEKELES]([C_INTEZMENYID] ASC, [C_TANEVID] ASC, [C_ERTEKELESOSZTALYZATID] ASC);


GO
PRINT N'Creating [dbo].[T_TANULOERTEKELES].[I_T_4025641_4028206]...';


GO
CREATE NONCLUSTERED INDEX [I_T_4025641_4028206]
    ON [dbo].[T_TANULOERTEKELES]([C_INTEZMENYID] ASC, [C_TANEVID] ASC, [C_ERTEKELESMODID] ASC);


GO
PRINT N'Creating [dbo].[T_TANULOERTEKELES].[I_T_4025641_4028210]...';


GO
CREATE NONCLUSTERED INDEX [I_T_4025641_4028210]
    ON [dbo].[T_TANULOERTEKELES]([C_INTEZMENYID] ASC, [C_TANEVID] ASC, [C_MAGATARTASERTEKID] ASC);


GO
PRINT N'Creating [dbo].[T_TANULOERTEKELES].[I_T_4025641_4028211]...';


GO
CREATE NONCLUSTERED INDEX [I_T_4025641_4028211]
    ON [dbo].[T_TANULOERTEKELES]([C_INTEZMENYID] ASC, [C_TANEVID] ASC, [C_MAGATARTASOSZTALYZATID] ASC);


GO
PRINT N'Creating [dbo].[T_TANULOERTEKELES].[I_T_4025641_4028214]...';


GO
CREATE NONCLUSTERED INDEX [I_T_4025641_4028214]
    ON [dbo].[T_TANULOERTEKELES]([C_INTEZMENYID] ASC, [C_TANEVID] ASC, [C_SZORGALOMERTEKID] ASC);


GO
PRINT N'Creating [dbo].[T_TANULOERTEKELES].[I_T_4025641_4028215]...';


GO
CREATE NONCLUSTERED INDEX [I_T_4025641_4028215]
    ON [dbo].[T_TANULOERTEKELES]([C_INTEZMENYID] ASC, [C_TANEVID] ASC, [C_SZORGALOMOSZTALYZATID] ASC);


GO
PRINT N'Creating [dbo].[T_TANULOERTEKELES].[I_T_4025662_4025660]...';


GO
CREATE NONCLUSTERED INDEX [I_T_4025662_4025660]
    ON [dbo].[T_TANULOERTEKELES]([C_TANTARGYID] ASC);


GO
PRINT N'Creating [dbo].[T_TANULOERTEKELES].[I_T_4025665_4025663]...';


GO
CREATE NONCLUSTERED INDEX [I_T_4025665_4025663]
    ON [dbo].[T_TANULOERTEKELES]([C_TANULOID] ASC);


GO
PRINT N'Creating [dbo].[T_TANULOERTEKELES].[I_T_4025668_4025666]...';


GO
CREATE NONCLUSTERED INDEX [I_T_4025668_4025666]
    ON [dbo].[T_TANULOERTEKELES]([C_OSZTALYCSOPORTID] ASC);


GO
PRINT N'Creating [dbo].[T_TANULOERTEKELES].[I_T_4025670_4025669]...';


GO
CREATE NONCLUSTERED INDEX [I_T_4025670_4025669]
    ON [dbo].[T_TANULOERTEKELES]([C_ERTEKELOID] ASC);


GO
PRINT N'Creating [dbo].[T_TANULOERTEKELES].[I_T_4025938_4025937]...';


GO
CREATE NONCLUSTERED INDEX [I_T_4025938_4025937]
    ON [dbo].[T_TANULOERTEKELES]([C_TANORAID] ASC);


GO
PRINT N'Creating [dbo].[T_TANULOERTEKELES].[I_T_4028380_4028379]...';


GO
CREATE NONCLUSTERED INDEX [I_T_4028380_4028379]
    ON [dbo].[T_TANULOERTEKELES]([C_OSSZEFUGGOSZAKGYAKID] ASC);


GO
PRINT N'Creating [dbo].[T_TANULOERTEKELES].[I_T_4028462_4028461]...';


GO
CREATE NONCLUSTERED INDEX [I_T_4028462_4028461]
    ON [dbo].[T_TANULOERTEKELES]([C_ROGZITESKORITANULOOSZTALYID] ASC);


GO
PRINT N'Creating [dbo].[T_TANULOERTEKELES].[I_T_402564102_402564100]...';


GO
CREATE NONCLUSTERED INDEX [I_T_402564102_402564100]
    ON [dbo].[T_TANULOERTEKELES]([C_INTEZMENYID] ASC);


GO
PRINT N'Creating [dbo].[T_TANULOERTEKELES].[I_T_402564105_402564103]...';


GO
CREATE NONCLUSTERED INDEX [I_T_402564105_402564103]
    ON [dbo].[T_TANULOERTEKELES]([C_TANEVID] ASC);


GO
PRINT N'Creating [dbo].[T_TANULOERTEKELES].[IDX_TANULOERTEKELES_TANULOID_TANTARGYID_ERTEKELESTIPUSA]...';


GO
CREATE NONCLUSTERED INDEX [IDX_TANULOERTEKELES_TANULOID_TANTARGYID_ERTEKELESTIPUSA]
    ON [dbo].[T_TANULOERTEKELES]([C_INTEZMENYID] ASC, [C_TANEVID] ASC, [C_TANULOID] ASC, [C_TANTARGYID] ASC, [C_TIPUSID] ASC);


GO
PRINT N'Creating [dbo].[T_TANULOERTEKELES].[IX_TANULOERTEKELES_TANULOID_TIPUSID_INTEZMENYID_TANEVID_ERTEKELESOSZTALYZATID]...';


GO
CREATE NONCLUSTERED INDEX [IX_TANULOERTEKELES_TANULOID_TIPUSID_INTEZMENYID_TANEVID_ERTEKELESOSZTALYZATID]
    ON [dbo].[T_TANULOERTEKELES]([C_TANULOID] ASC, [C_TIPUSID] ASC, [C_INTEZMENYID] ASC, [C_TANEVID] ASC, [C_ERTEKELESOSZTALYZATID] ASC)
    INCLUDE([C_ERTEKELESMODID], [C_ROGZITESKORITANULOOSZTALYID], [C_TANTARGYID]) WHERE ([TOROLT]='F');


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


GO
ALTER TABLE [dbo].[T_OSSZEFUGGOSZAKGYAK] WITH NOCHECK
    ADD CONSTRAINT [FK_4028372_4028370] FOREIGN KEY ([C_TANTARGYID]) REFERENCES [dbo].[T_TANTARGY] ([ID]);


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


GO
ALTER TABLE [dbo].[T_OSSZEFUGGOSZAKGYAK] WITH NOCHECK
    ADD CONSTRAINT [FK_4028375_4028373] FOREIGN KEY ([C_TANULOID]) REFERENCES [dbo].[T_TANULO] ([ID]);


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


GO
ALTER TABLE [dbo].[T_OSSZEFUGGOSZAKGYAK] WITH NOCHECK
    ADD CONSTRAINT [FK_4028378_4028376] FOREIGN KEY ([C_CSOPORTID]) REFERENCES [dbo].[T_CSOPORT] ([ID]);


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


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


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


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


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


GO
ALTER TABLE [dbo].[T_NAPLOELLENORZES] WITH NOCHECK
    ADD CONSTRAINT [FK_4025763_4025762] FOREIGN KEY ([C_OSZTALYID]) REFERENCES [dbo].[T_OSZTALY] ([ID]);


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


GO
ALTER TABLE [dbo].[T_OSZTALY] WITH NOCHECK
    ADD CONSTRAINT [FK_T_4025296_4025338] FOREIGN KEY ([ID]) REFERENCES [dbo].[T_OSZTALYCSOPORT] ([ID]);


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


GO
ALTER TABLE [dbo].[T_OSZTALY] WITH NOCHECK
    ADD CONSTRAINT [FK_4025320_4025319] FOREIGN KEY ([C_OSZTALYFONOKID]) REFERENCES [dbo].[T_ALKALMAZOTT] ([ID]);


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


GO
ALTER TABLE [dbo].[T_OSZTALY] WITH NOCHECK
    ADD CONSTRAINT [FK_4025323_4025322] FOREIGN KEY ([C_OFOHELYETTESID]) REFERENCES [dbo].[T_ALKALMAZOTT] ([ID]);


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


GO
ALTER TABLE [dbo].[T_OSZTALY] WITH NOCHECK
    ADD CONSTRAINT [FK_4025421_4025419] FOREIGN KEY ([C_TANTERVID]) REFERENCES [dbo].[T_TANTERV] ([ID]);


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


GO
ALTER TABLE [dbo].[T_OSZTALY] WITH NOCHECK
    ADD CONSTRAINT [FK_402529402_402529400] FOREIGN KEY ([C_ALINTEZMENYID]) REFERENCES [dbo].[T_INTEZMENY] ([ID]);


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


GO
ALTER TABLE [dbo].[T_OSZTALY] WITH NOCHECK
    ADD CONSTRAINT [FK_402529405_402529403] FOREIGN KEY ([C_ALTANEVID]) REFERENCES [dbo].[T_TANEV] ([ID]);


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


GO
ALTER TABLE [dbo].[T_OSZTALY] WITH NOCHECK
    ADD CONSTRAINT [FK_4025294_4025295] FOREIGN KEY ([C_KEPZESIFORMA], [C_ALINTEZMENYID], [C_ALTANEVID]) REFERENCES [dbo].[T_TANTERVIJELLEG] ([ID], [C_ALINTEZMENYID], [C_ALTANEVID]);


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


GO
ALTER TABLE [dbo].[T_OSZTALY] WITH NOCHECK
    ADD CONSTRAINT [FK_4025294_4027544] FOREIGN KEY ([C_AGAZAT], [C_ALINTEZMENYID], [C_ALTANEVID]) REFERENCES [dbo].[T_AGAZATTIPUS] ([ID], [C_ALINTEZMENYID], [C_ALTANEVID]);


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


GO
ALTER TABLE [dbo].[T_OSZTALY] WITH NOCHECK
    ADD CONSTRAINT [FK_4025294_4027545] FOREIGN KEY ([C_RESZSZAKKEPESITES], [C_ALINTEZMENYID], [C_ALTANEVID]) REFERENCES [dbo].[T_RESZSZAKKEPESITESTIPUS] ([ID], [C_ALINTEZMENYID], [C_ALTANEVID]);


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


GO
ALTER TABLE [dbo].[T_OSZTALY] WITH NOCHECK
    ADD CONSTRAINT [FK_4025294_4027546] FOREIGN KEY ([C_SZAKKEPESITES], [C_ALINTEZMENYID], [C_ALTANEVID]) REFERENCES [dbo].[T_SZAKKEPESITESTIPUS] ([ID], [C_ALINTEZMENYID], [C_ALTANEVID]);


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


GO
ALTER TABLE [dbo].[T_OSZTALY] WITH NOCHECK
    ADD CONSTRAINT [FK_4025294_4027547] FOREIGN KEY ([C_SZAKMACSOPORT], [C_ALINTEZMENYID], [C_ALTANEVID]) REFERENCES [dbo].[T_SZAKMACSOPORTTIPUS] ([ID], [C_ALINTEZMENYID], [C_ALTANEVID]);


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


GO
ALTER TABLE [dbo].[T_OSZTALY] WITH NOCHECK
    ADD CONSTRAINT [FK_4025294_4028299] FOREIGN KEY ([C_GIMNAZIUMIEVFOLYAMTIPUSID], [C_ALINTEZMENYID], [C_ALTANEVID]) REFERENCES [dbo].[T_GIMNAZIUMIEVFOLYAMTIPUS] ([ID], [C_ALINTEZMENYID], [C_ALTANEVID]);


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


GO
ALTER TABLE [dbo].[T_CSOPORT] WITH NOCHECK
    ADD CONSTRAINT [FK_4026206_4026204] FOREIGN KEY ([C_OSZTALYBONTASID]) REFERENCES [dbo].[T_OSZTALY] ([ID]);


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


GO
ALTER TABLE [dbo].[T_CSOPORTOK_OSZTALYOK] WITH NOCHECK
    ADD CONSTRAINT [FK_4025318_4025316] FOREIGN KEY ([C_OSZTALYOKID]) REFERENCES [dbo].[T_OSZTALY] ([ID]);


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


GO
ALTER TABLE [dbo].[T_ENAPLOHASZNALAT] WITH NOCHECK
    ADD CONSTRAINT [FK_402742005_402742003] FOREIGN KEY ([C_ALTANEVID]) REFERENCES [dbo].[T_TANEV] ([ID]);


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


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


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


GO
ALTER TABLE [dbo].[T_MESSAGESTATUS] WITH NOCHECK
    ADD CONSTRAINT [FK_402592605_402592603] FOREIGN KEY ([C_ALTANEVID]) REFERENCES [dbo].[T_TANEV] ([ID]);


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


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


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


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


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


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


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


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


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


GO
ALTER TABLE [dbo].[T_ENAPLOINFRA] WITH NOCHECK
    ADD CONSTRAINT [FK_402669305_402669303] FOREIGN KEY ([C_ALTANEVID]) REFERENCES [dbo].[T_TANEV] ([ID]);


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


GO
ALTER TABLE [dbo].[T_KKAMIJAZZZENETIPUS] WITH NOCHECK
    ADD CONSTRAINT [FK_402838905_402838903] FOREIGN KEY ([C_ALTANEVID]) REFERENCES [dbo].[T_TANEV] ([ID]);


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


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


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


GO
ALTER TABLE [dbo].[T_LATASSERULTTIPUS] WITH NOCHECK
    ADD CONSTRAINT [FK_402537005_402537003] FOREIGN KEY ([C_ALTANEVID]) REFERENCES [dbo].[T_TANEV] ([ID]);


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


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


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


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


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


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


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


GO
ALTER TABLE [dbo].[T_TAGOZATTIPUS] WITH NOCHECK
    ADD CONSTRAINT [FK_402739605_402739603] FOREIGN KEY ([C_ALTANEVID]) REFERENCES [dbo].[T_TANEV] ([ID]);


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


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


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


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


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


GO
ALTER TABLE [dbo].[T_PARTFILLSTATUS] WITH NOCHECK
    ADD CONSTRAINT [FK_402616205_402616203] FOREIGN KEY ([C_ALTANEVID]) REFERENCES [dbo].[T_TANEV] ([ID]);


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


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


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


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


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


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


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


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


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


GO
ALTER TABLE [dbo].[T_KKTANITOMUVTERTIPUS] WITH NOCHECK
    ADD CONSTRAINT [FK_402838805_402838803] FOREIGN KEY ([C_ALTANEVID]) REFERENCES [dbo].[T_TANEV] ([ID]);


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


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


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


GO
ALTER TABLE [dbo].[T_ETKEZESIKEDVEZMENYTIPUS] WITH NOCHECK
    ADD CONSTRAINT [FK_402536005_402536003] FOREIGN KEY ([C_ALTANEVID]) REFERENCES [dbo].[T_TANEV] ([ID]);


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


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


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


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


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


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


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


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


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


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


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


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


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


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


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


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


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


GO
ALTER TABLE [dbo].[T_MUNKAKORTIPUS] WITH NOCHECK
    ADD CONSTRAINT [FK_402515705_402515703] FOREIGN KEY ([C_ALTANEVID]) REFERENCES [dbo].[T_TANEV] ([ID]);


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


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


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


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


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


GO
ALTER TABLE [dbo].[T_KKAMIKLASSZIKUSTIPUS] WITH NOCHECK
    ADD CONSTRAINT [FK_402838705_402838703] FOREIGN KEY ([C_ALTANEVID]) REFERENCES [dbo].[T_TANEV] ([ID]);


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


GO
ALTER TABLE [dbo].[T_HATRANYOSHELYZETTIPUS] WITH NOCHECK
    ADD CONSTRAINT [FK_402535905_402535903] FOREIGN KEY ([C_ALTANEVID]) REFERENCES [dbo].[T_TANEV] ([ID]);


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


GO
ALTER TABLE [dbo].[T_OTPJELENTESSTATUS] WITH NOCHECK
    ADD CONSTRAINT [FK_249131205_249131203] FOREIGN KEY ([C_ALTANEVID]) REFERENCES [dbo].[T_TANEV] ([ID]);


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


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


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


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


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


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


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


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


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


GO
ALTER TABLE [dbo].[T_MAGATARTASERTEKELESTIPUS] WITH NOCHECK
    ADD CONSTRAINT [FK_402572105_402572103] FOREIGN KEY ([C_ALTANEVID]) REFERENCES [dbo].[T_TANEV] ([ID]);


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


GO
ALTER TABLE [dbo].[T_EVENTTYPE] WITH NOCHECK
    ADD CONSTRAINT [FK_402590105_402590103] FOREIGN KEY ([C_ALTANEVID]) REFERENCES [dbo].[T_TANEV] ([ID]);


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


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


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


GO
ALTER TABLE [dbo].[T_ORATULAJDONSAGTIPUS] WITH NOCHECK
    ADD CONSTRAINT [FK_402797005_402797003] FOREIGN KEY ([C_ALTANEVID]) REFERENCES [dbo].[T_TANEV] ([ID]);


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


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


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


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


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


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


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


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


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


GO
ALTER TABLE [dbo].[T_KKGYOGYPEDTERTIPUS] WITH NOCHECK
    ADD CONSTRAINT [FK_402838605_402838603] FOREIGN KEY ([C_ALTANEVID]) REFERENCES [dbo].[T_TANEV] ([ID]);


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


GO
ALTER TABLE [dbo].[T_VALLAS] WITH NOCHECK
    ADD CONSTRAINT [FK_402534005_402534003] FOREIGN KEY ([C_ALTANEVID]) REFERENCES [dbo].[T_TANEV] ([ID]);


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


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


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


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


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


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


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


GO
ALTER TABLE [dbo].[T_LICENCEFUNKCIOKTIPUS] WITH NOCHECK
    ADD CONSTRAINT [FK_402820405_402820403] FOREIGN KEY ([C_ALTANEVID]) REFERENCES [dbo].[T_TANEV] ([ID]);


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


GO
ALTER TABLE [dbo].[T_VEZETOIORASZAMOKTIPUS] WITH NOCHECK
    ADD CONSTRAINT [FK_402763405_402763403] FOREIGN KEY ([C_ALTANEVID]) REFERENCES [dbo].[T_TANEV] ([ID]);


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


GO
ALTER TABLE [dbo].[T_SZORGALOMERTEKELESTIPUS] WITH NOCHECK
    ADD CONSTRAINT [FK_402571705_402571703] FOREIGN KEY ([C_ALTANEVID]) REFERENCES [dbo].[T_TANEV] ([ID]);


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


GO
ALTER TABLE [dbo].[T_TANITASIORATULAJDONSAG] WITH NOCHECK
    ADD CONSTRAINT [FK_402795405_402795403] FOREIGN KEY ([C_TANEVID]) REFERENCES [dbo].[T_TANEV] ([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'Creating [dbo].[FK_402662505_402662503]...';


GO
ALTER TABLE [dbo].[T_ESLADATTIPUS] WITH NOCHECK
    ADD CONSTRAINT [FK_402662505_402662503] FOREIGN KEY ([C_ALTANEVID]) REFERENCES [dbo].[T_TANEV] ([ID]);


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


GO
ALTER TABLE [dbo].[T_KKKEPESITESTIPUS] WITH NOCHECK
    ADD CONSTRAINT [FK_402838505_402838503] FOREIGN KEY ([C_ALTANEVID]) REFERENCES [dbo].[T_TANEV] ([ID]);


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


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


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


GO
ALTER TABLE [dbo].[T_OTPJELENTESTIPUS] WITH NOCHECK
    ADD CONSTRAINT [FK_248860605_248860603] FOREIGN KEY ([C_ALTANEVID]) REFERENCES [dbo].[T_TANEV] ([ID]);


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


GO
ALTER TABLE [dbo].[T_ALKALMAZOTT] WITH NOCHECK
    ADD CONSTRAINT [FK_402513905_402513903] FOREIGN KEY ([C_ALTANEVID]) REFERENCES [dbo].[T_TANEV] ([ID]);


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


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


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


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


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


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


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


GO
ALTER TABLE [dbo].[T_FOGLALKOZTATASTIPUSA] WITH NOCHECK
    ADD CONSTRAINT [FK_402762905_402762903] FOREIGN KEY ([C_ALTANEVID]) REFERENCES [dbo].[T_TANEV] ([ID]);


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


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


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


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


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


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


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


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


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


GO
ALTER TABLE [dbo].[T_FELVETELSTATUSZATIPUS] WITH NOCHECK
    ADD CONSTRAINT [FK_402736205_402736203] FOREIGN KEY ([C_ALTANEVID]) REFERENCES [dbo].[T_TANEV] ([ID]);


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


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


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


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


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


GO
ALTER TABLE [dbo].[T_KKSZAKTIPUS] WITH NOCHECK
    ADD CONSTRAINT [FK_402838405_402838403] FOREIGN KEY ([C_ALTANEVID]) REFERENCES [dbo].[T_TANEV] ([ID]);


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


GO
ALTER TABLE [dbo].[T_SYSTEMSETTINGSCONTROLTYPE] WITH NOCHECK
    ADD CONSTRAINT [FK_402610905_402610903] FOREIGN KEY ([C_ALTANEVID]) REFERENCES [dbo].[T_TANEV] ([ID]);


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


GO
ALTER TABLE [dbo].[T_KOZTERULETJELLEG] WITH NOCHECK
    ADD CONSTRAINT [FK_242511905_242511903] FOREIGN KEY ([C_ALTANEVID]) REFERENCES [dbo].[T_TANEV] ([ID]);


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


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


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


GO
ALTER TABLE [dbo].[T_ERTMONDATBANKTIPUS] WITH NOCHECK
    ADD CONSTRAINT [FK_402846405_402846403] FOREIGN KEY ([C_ALTANEVID]) REFERENCES [dbo].[T_TANEV] ([ID]);


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


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


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


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


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


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


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


GO
ALTER TABLE [dbo].[T_ERETTSEGISZINT] WITH NOCHECK
    ADD CONSTRAINT [FK_402761905_402761903] FOREIGN KEY ([C_ALTANEVID]) REFERENCES [dbo].[T_TANEV] ([ID]);


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


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


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


GO
ALTER TABLE [dbo].[T_PENZNEMTIPUS] WITH NOCHECK
    ADD CONSTRAINT [FK_402818705_402818703] FOREIGN KEY ([C_ALTANEVID]) REFERENCES [dbo].[T_TANEV] ([ID]);


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


GO
ALTER TABLE [dbo].[T_ESEMENYTIPUS] WITH NOCHECK
    ADD CONSTRAINT [FK_402569805_402569803] FOREIGN KEY ([C_ALTANEVID]) REFERENCES [dbo].[T_TANEV] ([ID]);


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


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


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


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


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


GO
ALTER TABLE [dbo].[T_SOROLASOKATIPUS] WITH NOCHECK
    ADD CONSTRAINT [FK_402653905_402653903] FOREIGN KEY ([C_ALTANEVID]) REFERENCES [dbo].[T_TANEV] ([ID]);


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


GO
ALTER TABLE [dbo].[T_KKAMIZENEMUVKATTIPUS] WITH NOCHECK
    ADD CONSTRAINT [FK_402838305_402838303] FOREIGN KEY ([C_ALTANEVID]) REFERENCES [dbo].[T_TANEV] ([ID]);


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


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


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


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


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


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


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


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


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


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


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


GO
ALTER TABLE [dbo].[T_HETNAPJATIPUS] WITH NOCHECK
    ADD CONSTRAINT [FK_402544905_402544903] FOREIGN KEY ([C_ALTANEVID]) REFERENCES [dbo].[T_TANEV] ([ID]);


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


GO
ALTER TABLE [dbo].[T_ERETTSEGITIPUS] WITH NOCHECK
    ADD CONSTRAINT [FK_402761805_402761803] FOREIGN KEY ([C_ALTANEVID]) REFERENCES [dbo].[T_TANEV] ([ID]);


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


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


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


GO
ALTER TABLE [dbo].[T_ANYANYELV] WITH NOCHECK
    ADD CONSTRAINT [FK_402513805_402513803] FOREIGN KEY ([C_ALTANEVID]) REFERENCES [dbo].[T_TANEV] ([ID]);


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


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


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


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


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


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


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


GO
ALTER TABLE [dbo].[T_FORMTYPE] WITH NOCHECK
    ADD CONSTRAINT [FK_1546805_1546803] FOREIGN KEY ([C_ALTANEVID]) REFERENCES [dbo].[T_TANEV] ([ID]);


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


GO
ALTER TABLE [dbo].[T_IDOKERET] WITH NOCHECK
    ADD CONSTRAINT [FK_402719205_402719203] FOREIGN KEY ([C_ALTANEVID]) REFERENCES [dbo].[T_TANEV] ([ID]);


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


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


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


GO
ALTER TABLE [dbo].[T_KOZOSSEGISZOLGALATTIPUS] WITH NOCHECK
    ADD CONSTRAINT [FK_402791105_402791103] FOREIGN KEY ([C_ALTANEVID]) REFERENCES [dbo].[T_TANEV] ([ID]);


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


GO
ALTER TABLE [dbo].[T_MULASZTASSTATISZTIKATIPUS] WITH NOCHECK
    ADD CONSTRAINT [FK_402607805_402607803] FOREIGN KEY ([C_ALTANEVID]) REFERENCES [dbo].[T_TANEV] ([ID]);


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


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


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


GO
ALTER TABLE [dbo].[T_IGAZOLASTIPUS] WITH NOCHECK
    ADD CONSTRAINT [FK_402569605_402569603] FOREIGN KEY ([C_ALTANEVID]) REFERENCES [dbo].[T_TANEV] ([ID]);


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


GO
ALTER TABLE [dbo].[T_KKKEPESITESJELLTIPUS] WITH NOCHECK
    ADD CONSTRAINT [FK_402842705_402842703] FOREIGN KEY ([C_ALTANEVID]) REFERENCES [dbo].[T_TANEV] ([ID]);


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


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


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


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


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


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


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


GO
ALTER TABLE [dbo].[T_IGAZOLVANYTIPUS] WITH NOCHECK
    ADD CONSTRAINT [FK_402513405_402513403] FOREIGN KEY ([C_ALTANEVID]) REFERENCES [dbo].[T_TANEV] ([ID]);


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


GO
ALTER TABLE [dbo].[T_MEROHELYTIPUS] WITH NOCHECK
    ADD CONSTRAINT [FK_402818305_402818303] FOREIGN KEY ([C_ALTANEVID]) REFERENCES [dbo].[T_TANEV] ([ID]);


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


GO
ALTER TABLE [dbo].[T_ERRORSTATUS] WITH NOCHECK
    ADD CONSTRAINT [FK_53988005_53988003] FOREIGN KEY ([C_ALTANEVID]) REFERENCES [dbo].[T_TANEV] ([ID]);


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


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


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


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


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


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


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


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


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


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


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


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


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


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


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


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


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


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


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


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


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


GO
ALTER TABLE [dbo].[T_SCCARDBEVONASOKA] WITH NOCHECK
    ADD CONSTRAINT [FK_383219005_383219003] FOREIGN KEY ([C_ALTANEVID]) REFERENCES [dbo].[T_TANEV] ([ID]);


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


GO
ALTER TABLE [dbo].[T_MUNKAVISZONYTIPUS] WITH NOCHECK
    ADD CONSTRAINT [FK_402513305_402513303] FOREIGN KEY ([C_ALTANEVID]) REFERENCES [dbo].[T_TANEV] ([ID]);


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


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


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


GO
ALTER TABLE [dbo].[T_FEETYPE] WITH NOCHECK
    ADD CONSTRAINT [FK_28379705_28379703] FOREIGN KEY ([C_ALTANEVID]) REFERENCES [dbo].[T_TANEV] ([ID]);


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


GO
ALTER TABLE [dbo].[T_OSSZEGTULLEPESTIPUS] WITH NOCHECK
    ADD CONSTRAINT [FK_402718805_402718803] FOREIGN KEY ([C_ALTANEVID]) REFERENCES [dbo].[T_TANEV] ([ID]);


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


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


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


GO
ALTER TABLE [dbo].[T_MUNKAIDOKEDVEZMENYOKA] WITH NOCHECK
    ADD CONSTRAINT [FK_402636605_402636603] FOREIGN KEY ([C_ALTANEVID]) REFERENCES [dbo].[T_TANEV] ([ID]);


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


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


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


GO
ALTER TABLE [dbo].[T_HETIRENDTIPUS] WITH NOCHECK
    ADD CONSTRAINT [FK_402544005_402544003] FOREIGN KEY ([C_ALTANEVID]) REFERENCES [dbo].[T_TANEV] ([ID]);


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


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


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


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


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


GO
ALTER TABLE [dbo].[T_TANTERVIJELLEG] WITH NOCHECK
    ADD CONSTRAINT [FK_402529305_402529303] FOREIGN KEY ([C_ALTANEVID]) REFERENCES [dbo].[T_TANEV] ([ID]);


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


GO
ALTER TABLE [dbo].[T_MULASZTASTIPUS] WITH NOCHECK
    ADD CONSTRAINT [FK_402565905_402565903] FOREIGN KEY ([C_ALTANEVID]) REFERENCES [dbo].[T_TANEV] ([ID]);


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


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


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


GO
ALTER TABLE [dbo].[T_DIAKIGAZOLVANYIGENYSTATUSZ] WITH NOCHECK
    ADD CONSTRAINT [FK_202649705_202649703] FOREIGN KEY ([C_ALTANEVID]) REFERENCES [dbo].[T_TANEV] ([ID]);


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


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


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


GO
ALTER TABLE [dbo].[T_ERETTSEGITANTARGY] WITH NOCHECK
    ADD CONSTRAINT [FK_402759805_402759803] FOREIGN KEY ([C_ALTANEVID]) REFERENCES [dbo].[T_TANEV] ([ID]);


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


GO
ALTER TABLE [dbo].[T_MEGYE] WITH NOCHECK
    ADD CONSTRAINT [FK_371584605_371584603] FOREIGN KEY ([C_ALTANEVID]) REFERENCES [dbo].[T_TANEV] ([ID]);


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


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


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


GO
ALTER TABLE [dbo].[T_PAYMENTTITLETYPE] WITH NOCHECK
    ADD CONSTRAINT [FK_22824705_22824703] FOREIGN KEY ([C_ALTANEVID]) REFERENCES [dbo].[T_TANEV] ([ID]);


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


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


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


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


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


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


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


GO
ALTER TABLE [dbo].[T_BESOROLASIFOKOZATTIPUS] WITH NOCHECK
    ADD CONSTRAINT [FK_402635305_402635303] FOREIGN KEY ([C_ALTANEVID]) REFERENCES [dbo].[T_TANEV] ([ID]);


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


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


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


GO
ALTER TABLE [dbo].[T_NAPTIPUS] WITH NOCHECK
    ADD CONSTRAINT [FK_402543905_402543903] FOREIGN KEY ([C_ALTANEVID]) REFERENCES [dbo].[T_TANEV] ([ID]);


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


GO
ALTER TABLE [dbo].[T_ERTESITESTIPUS] WITH NOCHECK
    ADD CONSTRAINT [FK_402586505_402586503] FOREIGN KEY ([C_ALTANEVID]) REFERENCES [dbo].[T_TANEV] ([ID]);


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


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


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


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


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


GO
ALTER TABLE [dbo].[T_TESTNEVELESTIPUS] WITH NOCHECK
    ADD CONSTRAINT [FK_402527905_402527903] FOREIGN KEY ([C_ALTANEVID]) REFERENCES [dbo].[T_TANEV] ([ID]);


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


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


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


GO
ALTER TABLE [dbo].[T_SCSTICKERSTATUS] WITH NOCHECK
    ADD CONSTRAINT [FK_202649405_202649403] FOREIGN KEY ([C_ALTANEVID]) REFERENCES [dbo].[T_TANEV] ([ID]);


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


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


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


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


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


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


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


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


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


GO
ALTER TABLE [dbo].[T_EMAILTIPUS] WITH NOCHECK
    ADD CONSTRAINT [FK_4247205_4247203] FOREIGN KEY ([C_ALTANEVID]) REFERENCES [dbo].[T_TANEV] ([ID]);


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


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


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


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


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


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


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


GO
ALTER TABLE [dbo].[T_EPENZTARCATETELSTATUSZ] WITH NOCHECK
    ADD CONSTRAINT [FK_402718005_402718003] FOREIGN KEY ([C_ALTANEVID]) REFERENCES [dbo].[T_TANEV] ([ID]);


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


GO
ALTER TABLE [dbo].[T_FELHASZNALOERTESITES] WITH NOCHECK
    ADD CONSTRAINT [FK_402586305_402586303] FOREIGN KEY ([C_TANEVID]) REFERENCES [dbo].[T_TANEV] ([ID]);


GO
PRINT N'Creating [dbo].[FK_402512105_402512103]...';


GO
ALTER TABLE [dbo].[T_ESZKOZTIPUS] WITH NOCHECK
    ADD CONSTRAINT [FK_402512105_402512103] FOREIGN KEY ([C_ALTANEVID]) REFERENCES [dbo].[T_TANEV] ([ID]);


GO
PRINT N'Creating [dbo].[FK_402601005_402601003]...';


GO
ALTER TABLE [dbo].[T_FELADATELLATASIHELY] WITH NOCHECK
    ADD CONSTRAINT [FK_402601005_402601003] FOREIGN KEY ([C_TANEVID]) REFERENCES [dbo].[T_TANEV] ([ID]);


GO
PRINT N'Creating [dbo].[FK_1404405_1404403]...';


GO
ALTER TABLE [dbo].[T_IMPOSITIONGROUP] WITH NOCHECK
    ADD CONSTRAINT [FK_1404405_1404403] FOREIGN KEY ([C_TANEVID]) REFERENCES [dbo].[T_TANEV] ([ID]);


GO
PRINT N'Creating [dbo].[FK_402527805_402527803]...';


GO
ALTER TABLE [dbo].[T_ESZKOZJELLEG] WITH NOCHECK
    ADD CONSTRAINT [FK_402527805_402527803] FOREIGN KEY ([C_ALTANEVID]) REFERENCES [dbo].[T_TANEV] ([ID]);


GO
PRINT N'Creating [dbo].[FK_402565305_402565303]...';


GO
ALTER TABLE [dbo].[T_ERTEKELESMOD] WITH NOCHECK
    ADD CONSTRAINT [FK_402565305_402565303] FOREIGN KEY ([C_ALTANEVID]) REFERENCES [dbo].[T_TANEV] ([ID]);


GO
PRINT N'Creating [dbo].[FK_402816605_402816603]...';


GO
ALTER TABLE [dbo].[T_KOZMUSZAMLATIPUS] WITH NOCHECK
    ADD CONSTRAINT [FK_402816605_402816603] FOREIGN KEY ([C_ALTANEVID]) REFERENCES [dbo].[T_TANEV] ([ID]);


GO
PRINT N'Creating [dbo].[FK_402542505_402542503]...';


GO
ALTER TABLE [dbo].[T_FOGLALKOZASTIPUS] WITH NOCHECK
    ADD CONSTRAINT [FK_402542505_402542503] FOREIGN KEY ([C_ALTANEVID]) REFERENCES [dbo].[T_TANEV] ([ID]);


GO
PRINT N'Creating [dbo].[FK_193161505_193161503]...';


GO
ALTER TABLE [dbo].[T_MUNKAVISZONYJELLEGE] WITH NOCHECK
    ADD CONSTRAINT [FK_193161505_193161503] FOREIGN KEY ([C_ALTANEVID]) REFERENCES [dbo].[T_TANEV] ([ID]);


GO
PRINT N'Creating [dbo].[FK_402841905_402841903]...';


GO
ALTER TABLE [dbo].[T_KKGYOGYPEDVEGZETTSEG] WITH NOCHECK
    ADD CONSTRAINT [FK_402841905_402841903] FOREIGN KEY ([C_TANEVID]) REFERENCES [dbo].[T_TANEV] ([ID]);


GO
PRINT N'Creating [dbo].[FK_402783305_402783303]...';


GO
ALTER TABLE [dbo].[T_OGORARENDIORA] WITH NOCHECK
    ADD CONSTRAINT [FK_402783305_402783303] FOREIGN KEY ([C_TANEVID]) REFERENCES [dbo].[T_TANEV] ([ID]);


GO
PRINT N'Creating [dbo].[FK_331018805_331018803]...';


GO
ALTER TABLE [dbo].[T_EMAILUZENET] WITH NOCHECK
    ADD CONSTRAINT [FK_331018805_331018803] FOREIGN KEY ([C_TANEVID]) REFERENCES [dbo].[T_TANEV] ([ID]);


GO
PRINT N'Creating [dbo].[FK_4165705_4165703]...';


GO
ALTER TABLE [dbo].[T_TELEFONTIPUS] WITH NOCHECK
    ADD CONSTRAINT [FK_4165705_4165703] FOREIGN KEY ([C_ALTANEVID]) REFERENCES [dbo].[T_TANEV] ([ID]);


GO
PRINT N'Creating [dbo].[FK_402755005_402755003]...';


GO
ALTER TABLE [dbo].[T_RESZSZAKKEPESITESTIPUS] WITH NOCHECK
    ADD CONSTRAINT [FK_402755005_402755003] FOREIGN KEY ([C_ALTANEVID]) REFERENCES [dbo].[T_TANEV] ([ID]);


GO
PRINT N'Creating [dbo].[FK_402831405_402831403]...';


GO
ALTER TABLE [dbo].[T_KIRKONTENERELEM] WITH NOCHECK
    ADD CONSTRAINT [FK_402831405_402831403] FOREIGN KEY ([C_TANEVID]) REFERENCES [dbo].[T_TANEV] ([ID]);


GO
PRINT N'Creating [dbo].[FK_402717105_402717103]...';


GO
ALTER TABLE [dbo].[T_EPENZTARCAPARAMETEREK] WITH NOCHECK
    ADD CONSTRAINT [FK_402717105_402717103] FOREIGN KEY ([C_TANEVID]) REFERENCES [dbo].[T_TANEV] ([ID]);


GO
PRINT N'Creating [dbo].[FK_402586205_402586203]...';


GO
ALTER TABLE [dbo].[T_ERTESITESSZINTIPUS] WITH NOCHECK
    ADD CONSTRAINT [FK_402586205_402586203] FOREIGN KEY ([C_ALTANEVID]) REFERENCES [dbo].[T_TANEV] ([ID]);


GO
PRINT N'Creating [dbo].[FK_402512005_402512003]...';


GO
ALTER TABLE [dbo].[T_ESZKOZKATEGORIA] WITH NOCHECK
    ADD CONSTRAINT [FK_402512005_402512003] FOREIGN KEY ([C_ALTANEVID]) REFERENCES [dbo].[T_TANEV] ([ID]);


GO
PRINT N'Creating [dbo].[FK_402600505_402600503]...';


GO
ALTER TABLE [dbo].[T_KIZAROCSOPORT] WITH NOCHECK
    ADD CONSTRAINT [FK_402600505_402600503] FOREIGN KEY ([C_TANEVID]) REFERENCES [dbo].[T_TANEV] ([ID]);


GO
PRINT N'Creating [dbo].[FK_402527705_402527703]...';


GO
ALTER TABLE [dbo].[T_CSOPORT] WITH NOCHECK
    ADD CONSTRAINT [FK_402527705_402527703] FOREIGN KEY ([C_ALTANEVID]) REFERENCES [dbo].[T_TANEV] ([ID]);


GO
PRINT N'Creating [dbo].[FK_402634205_402634203]...';


GO
ALTER TABLE [dbo].[T_PEDAGOGUSSTATUSZ] WITH NOCHECK
    ADD CONSTRAINT [FK_402634205_402634203] FOREIGN KEY ([C_ALTANEVID]) REFERENCES [dbo].[T_TANEV] ([ID]);


GO
PRINT N'Creating [dbo].[FK_402565205_402565203]...';


GO
ALTER TABLE [dbo].[T_OSZTALYZATTIPUS] WITH NOCHECK
    ADD CONSTRAINT [FK_402565205_402565203] FOREIGN KEY ([C_ALTANEVID]) REFERENCES [dbo].[T_TANEV] ([ID]);


GO
PRINT N'Creating [dbo].[FK_402542205_402542203]...';


GO
ALTER TABLE [dbo].[T_FOGLALKOZAS] WITH NOCHECK
    ADD CONSTRAINT [FK_402542205_402542203] FOREIGN KEY ([C_TANEVID]) REFERENCES [dbo].[T_TANEV] ([ID]);


GO
PRINT N'Creating [dbo].[FK_176808005_176808003]...';


GO
ALTER TABLE [dbo].[T_KULFOLDISTATUSZTIPUS] WITH NOCHECK
    ADD CONSTRAINT [FK_176808005_176808003] FOREIGN KEY ([C_ALTANEVID]) REFERENCES [dbo].[T_TANEV] ([ID]);


GO
PRINT N'Creating [dbo].[FK_402841605_402841603]...';


GO
ALTER TABLE [dbo].[T_KKNEPZENE] WITH NOCHECK
    ADD CONSTRAINT [FK_402841605_402841603] FOREIGN KEY ([C_TANEVID]) REFERENCES [dbo].[T_TANEV] ([ID]);


GO
PRINT N'Creating [dbo].[FK_402776105_402776103]...';


GO
ALTER TABLE [dbo].[T_OGINTEZMENYFOGLALTSAG] WITH NOCHECK
    ADD CONSTRAINT [FK_402776105_402776103] FOREIGN KEY ([C_TANEVID]) REFERENCES [dbo].[T_TANEV] ([ID]);


GO
PRINT N'Creating [dbo].[FK_1331005_1331003]...';


GO
ALTER TABLE [dbo].[T_FINANCIALCODE] WITH NOCHECK
    ADD CONSTRAINT [FK_1331005_1331003] FOREIGN KEY ([C_TANEVID]) REFERENCES [dbo].[T_TANEV] ([ID]);


GO
PRINT N'Creating [dbo].[FK_3874305_3874303]...';


GO
ALTER TABLE [dbo].[T_PAYINGTYPE] WITH NOCHECK
    ADD CONSTRAINT [FK_3874305_3874303] FOREIGN KEY ([C_ALTANEVID]) REFERENCES [dbo].[T_TANEV] ([ID]);


GO
PRINT N'Creating [dbo].[FK_319582805_319582803]...';


GO
ALTER TABLE [dbo].[T_FELHASZNALOBELEPESTORTENET] WITH NOCHECK
    ADD CONSTRAINT [FK_319582805_319582803] FOREIGN KEY ([C_TANEVID]) REFERENCES [dbo].[T_TANEV] ([ID]);


GO
PRINT N'Creating [dbo].[FK_402754905_402754903]...';


GO
ALTER TABLE [dbo].[T_AGAZATTIPUS] WITH NOCHECK
    ADD CONSTRAINT [FK_402754905_402754903] FOREIGN KEY ([C_ALTANEVID]) REFERENCES [dbo].[T_TANEV] ([ID]);


GO
PRINT N'Creating [dbo].[FK_402831205_402831203]...';


GO
ALTER TABLE [dbo].[T_KIRSZOLGALTATASTIPUS] WITH NOCHECK
    ADD CONSTRAINT [FK_402831205_402831203] FOREIGN KEY ([C_ALTANEVID]) REFERENCES [dbo].[T_TANEV] ([ID]);


GO
PRINT N'Creating [dbo].[FK_402583905_402583903]...';


GO
ALTER TABLE [dbo].[T_TEVEKENYSEG] WITH NOCHECK
    ADD CONSTRAINT [FK_402583905_402583903] FOREIGN KEY ([C_TANEVID]) REFERENCES [dbo].[T_TANEV] ([ID]);


GO
PRINT N'Creating [dbo].[FK_402509805_402509803]...';


GO
ALTER TABLE [dbo].[T_ESZKOZ] WITH NOCHECK
    ADD CONSTRAINT [FK_402509805_402509803] FOREIGN KEY ([C_TANEVID]) REFERENCES [dbo].[T_TANEV] ([ID]);


GO
PRINT N'Creating [dbo].[FK_402600405_402600403]...';


GO
ALTER TABLE [dbo].[T_RENDSZERBEALLITASTIPUS] WITH NOCHECK
    ADD CONSTRAINT [FK_402600405_402600403] FOREIGN KEY ([C_ALTANEVID]) REFERENCES [dbo].[T_TANEV] ([ID]);


GO
PRINT N'Creating [dbo].[FK_402527605_402527603]...';


GO
ALTER TABLE [dbo].[T_ESZKOZCEL] WITH NOCHECK
    ADD CONSTRAINT [FK_402527605_402527603] FOREIGN KEY ([C_ALTANEVID]) REFERENCES [dbo].[T_TANEV] ([ID]);


GO
PRINT N'Creating [dbo].[FK_402633905_402633903]...';


GO
ALTER TABLE [dbo].[T_KRETATIPUS] WITH NOCHECK
    ADD CONSTRAINT [FK_402633905_402633903] FOREIGN KEY ([C_ALTANEVID]) REFERENCES [dbo].[T_TANEV] ([ID]);


GO
PRINT N'Creating [dbo].[FK_402565105_402565103]...';


GO
ALTER TABLE [dbo].[T_ERTEKELESTIPUS] WITH NOCHECK
    ADD CONSTRAINT [FK_402565105_402565103] FOREIGN KEY ([C_ALTANEVID]) REFERENCES [dbo].[T_TANEV] ([ID]);


GO
PRINT N'Creating [dbo].[FK_402814805_402814803]...';


GO
ALTER TABLE [dbo].[T_JELSZOVISSZAALLITAS] WITH NOCHECK
    ADD CONSTRAINT [FK_402814805_402814803] FOREIGN KEY ([C_TANEVID]) REFERENCES [dbo].[T_TANEV] ([ID]);


GO
PRINT N'Creating [dbo].[FK_163886705_163886703]...';


GO
ALTER TABLE [dbo].[T_VPOSCONFIG] WITH NOCHECK
    ADD CONSTRAINT [FK_163886705_163886703] FOREIGN KEY ([C_TANEVID]) REFERENCES [dbo].[T_TANEV] ([ID]);


GO
PRINT N'Creating [dbo].[FK_402841405_402841403]...';


GO
ALTER TABLE [dbo].[T_KKELEKTROAKUZENE] WITH NOCHECK
    ADD CONSTRAINT [FK_402841405_402841403] FOREIGN KEY ([C_TANEVID]) REFERENCES [dbo].[T_TANEV] ([ID]);


GO
PRINT N'Creating [dbo].[FK_3872705_3872703]...';


GO
ALTER TABLE [dbo].[T_ALLAMPOLGARSAG] WITH NOCHECK
    ADD CONSTRAINT [FK_3872705_3872703] FOREIGN KEY ([C_ALTANEVID]) REFERENCES [dbo].[T_TANEV] ([ID]);


GO
PRINT N'Creating [dbo].[FK_402695805_402695803]...';


GO
ALTER TABLE [dbo].[T_HIBAJEGY] WITH NOCHECK
    ADD CONSTRAINT [FK_402695805_402695803] FOREIGN KEY ([C_TANEVID]) REFERENCES [dbo].[T_TANEV] ([ID]);


GO
PRINT N'Creating [dbo].[FK_402775105_402775103]...';


GO
ALTER TABLE [dbo].[T_OGGENERATORALAP] WITH NOCHECK
    ADD CONSTRAINT [FK_402775105_402775103] FOREIGN KEY ([C_TANEVID]) REFERENCES [dbo].[T_TANEV] ([ID]);


GO
PRINT N'Creating [dbo].[FK_1324505_1324503]...';


GO
ALTER TABLE [dbo].[T_FEE] WITH NOCHECK
    ADD CONSTRAINT [FK_1324505_1324503] FOREIGN KEY ([C_TANEVID]) REFERENCES [dbo].[T_TANEV] ([ID]);


GO
PRINT N'Creating [dbo].[FK_402754805_402754803]...';


GO
ALTER TABLE [dbo].[T_SZAKMACSOPORTTIPUS] WITH NOCHECK
    ADD CONSTRAINT [FK_402754805_402754803] FOREIGN KEY ([C_ALTANEVID]) REFERENCES [dbo].[T_TANEV] ([ID]);


GO
PRINT N'Creating [dbo].[FK_304453105_304453103]...';


GO
ALTER TABLE [dbo].[T_HONAPOK] WITH NOCHECK
    ADD CONSTRAINT [FK_304453105_304453103] FOREIGN KEY ([C_ALTANEVID]) REFERENCES [dbo].[T_TANEV] ([ID]);


GO
PRINT N'Creating [dbo].[FK_402830805_402830803]...';


GO
ALTER TABLE [dbo].[T_SZAKTIPUS] WITH NOCHECK
    ADD CONSTRAINT [FK_402830805_402830803] FOREIGN KEY ([C_ALTANEVID]) REFERENCES [dbo].[T_TANEV] ([ID]);


GO
PRINT N'Creating [dbo].[FK_402540605_402540603]...';


GO
ALTER TABLE [dbo].[T_TARGYKATEGORIATIPUS] WITH NOCHECK
    ADD CONSTRAINT [FK_402540605_402540603] FOREIGN KEY ([C_ALTANEVID]) REFERENCES [dbo].[T_TANEV] ([ID]);


GO
PRINT N'Creating [dbo].[FK_402583805_402583803]...';


GO
ALTER TABLE [dbo].[T_TEVEKENYSEGTIPUS] WITH NOCHECK
    ADD CONSTRAINT [FK_402583805_402583803] FOREIGN KEY ([C_ALTANEVID]) REFERENCES [dbo].[T_TANEV] ([ID]);


GO
PRINT N'Creating [dbo].[FK_402600205_402600203]...';


GO
ALTER TABLE [dbo].[T_ORATERVTARGY] WITH NOCHECK
    ADD CONSTRAINT [FK_402600205_402600203] FOREIGN KEY ([C_TANEVID]) REFERENCES [dbo].[T_TANEV] ([ID]);


GO
PRINT N'Creating [dbo].[FK_402524605_402524603]...';


GO
ALTER TABLE [dbo].[T_MERTEKEGYSEGTIPUS] WITH NOCHECK
    ADD CONSTRAINT [FK_402524605_402524603] FOREIGN KEY ([C_ALTANEVID]) REFERENCES [dbo].[T_TANEV] ([ID]);


GO
PRINT N'Creating [dbo].[FK_402564105_402564103]...';


GO
ALTER TABLE [dbo].[T_TANULOERTEKELES] WITH NOCHECK
    ADD CONSTRAINT [FK_402564105_402564103] FOREIGN KEY ([C_TANEVID]) REFERENCES [dbo].[T_TANEV] ([ID]);


GO
PRINT N'Creating [dbo].[FK_402813505_402813503]...';


GO
ALTER TABLE [dbo].[T_HITTANADATSZOLGALTATAS] WITH NOCHECK
    ADD CONSTRAINT [FK_402813505_402813503] FOREIGN KEY ([C_TANEVID]) REFERENCES [dbo].[T_TANEV] ([ID]);


GO
PRINT N'Creating [dbo].[FK_136198505_136198503]...';


GO
ALTER TABLE [dbo].[T_SMS] WITH NOCHECK
    ADD CONSTRAINT [FK_136198505_136198503] FOREIGN KEY ([C_TANEVID]) REFERENCES [dbo].[T_TANEV] ([ID]);


GO
PRINT N'Creating [dbo].[FK_402841205_402841203]...';


GO
ALTER TABLE [dbo].[T_KKTERULET] WITH NOCHECK
    ADD CONSTRAINT [FK_402841205_402841203] FOREIGN KEY ([C_TANEVID]) REFERENCES [dbo].[T_TANEV] ([ID]);


GO
PRINT N'Creating [dbo].[FK_402509605_402509603]...';


GO
ALTER TABLE [dbo].[T_INGYENESTANKONYVELLATAS] WITH NOCHECK
    ADD CONSTRAINT [FK_402509605_402509603] FOREIGN KEY ([C_ALTANEVID]) REFERENCES [dbo].[T_TANEV] ([ID]);


GO
PRINT N'Creating [dbo].[FK_3867705_3867703]...';


GO
ALTER TABLE [dbo].[T_STUDENTCARDSTATUS] WITH NOCHECK
    ADD CONSTRAINT [FK_3867705_3867703] FOREIGN KEY ([C_ALTANEVID]) REFERENCES [dbo].[T_TANEV] ([ID]);


GO
PRINT N'Creating [dbo].[FK_402753905_402753903]...';


GO
ALTER TABLE [dbo].[T_SZAKKEPESITESTIPUS] WITH NOCHECK
    ADD CONSTRAINT [FK_402753905_402753903] FOREIGN KEY ([C_ALTANEVID]) REFERENCES [dbo].[T_TANEV] ([ID]);


GO
PRINT N'Creating [dbo].[FK_289347005_289347003]...';


GO
ALTER TABLE [dbo].[T_PAYMENTTITLE_ROLES] WITH NOCHECK
    ADD CONSTRAINT [FK_289347005_289347003] FOREIGN KEY ([C_TANEVID]) REFERENCES [dbo].[T_TANEV] ([ID]);


GO
PRINT N'Creating [dbo].[FK_402774605_402774603]...';


GO
ALTER TABLE [dbo].[T_OGOSZTALYCSOPORTFOGLALTSAG] WITH NOCHECK
    ADD CONSTRAINT [FK_402774605_402774603] FOREIGN KEY ([C_TANEVID]) REFERENCES [dbo].[T_TANEV] ([ID]);


GO
PRINT N'Creating [dbo].[FK_402830505_402830503]...';


GO
ALTER TABLE [dbo].[T_GIMNAZIUMIEVFOLYAMTIPUS] WITH NOCHECK
    ADD CONSTRAINT [FK_402830505_402830503] FOREIGN KEY ([C_ALTANEVID]) REFERENCES [dbo].[T_TANEV] ([ID]);


GO
PRINT N'Creating [dbo].[FK_402540505_402540503]...';


GO
ALTER TABLE [dbo].[T_EVFOLYAMTIPUS] WITH NOCHECK
    ADD CONSTRAINT [FK_402540505_402540503] FOREIGN KEY ([C_ALTANEVID]) REFERENCES [dbo].[T_TANEV] ([ID]);


GO
PRINT N'Creating [dbo].[FK_402581505_402581503]...';


GO
ALTER TABLE [dbo].[T_FALIUJSAGBEJEGYZES] WITH NOCHECK
    ADD CONSTRAINT [FK_402581505_402581503] FOREIGN KEY ([C_TANEVID]) REFERENCES [dbo].[T_TANEV] ([ID]);


GO
PRINT N'Creating [dbo].[FK_402599705_402599703]...';


GO
ALTER TABLE [dbo].[T_RENDSZERBEALLITAS] WITH NOCHECK
    ADD CONSTRAINT [FK_402599705_402599703] FOREIGN KEY ([C_TANEVID]) REFERENCES [dbo].[T_TANEV] ([ID]);


GO
PRINT N'Creating [dbo].[FK_1309205_1309203]...';


GO
ALTER TABLE [dbo].[T_SZEREPKOR] WITH NOCHECK
    ADD CONSTRAINT [FK_1309205_1309203] FOREIGN KEY ([C_TANEVID]) REFERENCES [dbo].[T_TANEV] ([ID]);


GO
PRINT N'Creating [dbo].[FK_4026244_4026243]...';


GO
ALTER TABLE [dbo].[T_INTEZMENYADATOK] WITH NOCHECK
    ADD CONSTRAINT [FK_4026244_4026243] FOREIGN KEY ([C_TANEVID]) REFERENCES [dbo].[T_TANEV] ([ID]);


GO
PRINT N'Creating [dbo].[FK_402629405_402629403]...';


GO
ALTER TABLE [dbo].[T_NAPTARIHET] WITH NOCHECK
    ADD CONSTRAINT [FK_402629405_402629403] FOREIGN KEY ([C_TANEVID]) REFERENCES [dbo].[T_TANEV] ([ID]);


GO
PRINT N'Creating [dbo].[FK_402557505_402557503]...';


GO
ALTER TABLE [dbo].[T_TANITASIORA] WITH NOCHECK
    ADD CONSTRAINT [FK_402557505_402557503] FOREIGN KEY ([C_TANEVID]) REFERENCES [dbo].[T_TANEV] ([ID]);


GO
PRINT N'Creating [dbo].[FK_402695305_402695303]...';


GO
ALTER TABLE [dbo].[T_HIBAJEGYSTATUSZ] WITH NOCHECK
    ADD CONSTRAINT [FK_402695305_402695303] FOREIGN KEY ([C_ALTANEVID]) REFERENCES [dbo].[T_TANEV] ([ID]);


GO
PRINT N'Creating [dbo].[FK_402840905_402840903]...';


GO
ALTER TABLE [dbo].[T_KKTANARVEGZETTSEG] WITH NOCHECK
    ADD CONSTRAINT [FK_402840905_402840903] FOREIGN KEY ([C_TANEVID]) REFERENCES [dbo].[T_TANEV] ([ID]);


GO
PRINT N'Creating [dbo].[FK_402509305_402509303]...';


GO
ALTER TABLE [dbo].[T_TEREMTIPUS] WITH NOCHECK
    ADD CONSTRAINT [FK_402509305_402509303] FOREIGN KEY ([C_ALTANEVID]) REFERENCES [dbo].[T_TANEV] ([ID]);


GO
PRINT N'Creating [dbo].[FK_402813305_402813303]...';


GO
ALTER TABLE [dbo].[T_HITTANTIPUS] WITH NOCHECK
    ADD CONSTRAINT [FK_402813305_402813303] FOREIGN KEY ([C_ALTANEVID]) REFERENCES [dbo].[T_TANEV] ([ID]);


GO
PRINT N'Creating [dbo].[FK_136178505_136178503]...';


GO
ALTER TABLE [dbo].[T_SMSMESSAGESTATUS] WITH NOCHECK
    ADD CONSTRAINT [FK_136178505_136178503] FOREIGN KEY ([C_ALTANEVID]) REFERENCES [dbo].[T_TANEV] ([ID]);


GO
PRINT N'Creating [dbo].[FK_3863705_3863703]...';


GO
ALTER TABLE [dbo].[T_NATIONALITY] WITH NOCHECK
    ADD CONSTRAINT [FK_3863705_3863703] FOREIGN KEY ([C_ALTANEVID]) REFERENCES [dbo].[T_TANEV] ([ID]);


GO
PRINT N'Creating [dbo].[FK_402750405_402750403]...';


GO
ALTER TABLE [dbo].[T_MUKODESIHELYTIPUS] WITH NOCHECK
    ADD CONSTRAINT [FK_402750405_402750403] FOREIGN KEY ([C_ALTANEVID]) REFERENCES [dbo].[T_TANEV] ([ID]);


GO
PRINT N'Creating [dbo].[FK_402829405_402829403]...';


GO
ALTER TABLE [dbo].[T_KEPESITES] WITH NOCHECK
    ADD CONSTRAINT [FK_402829405_402829403] FOREIGN KEY ([C_TANEVID]) REFERENCES [dbo].[T_TANEV] ([ID]);


GO
PRINT N'Creating [dbo].[FK_402581305_402581303]...';


GO
ALTER TABLE [dbo].[T_FALIUJSAGLATOGATTOTSAG] WITH NOCHECK
    ADD CONSTRAINT [FK_402581305_402581303] FOREIGN KEY ([C_TANEVID]) REFERENCES [dbo].[T_TANEV] ([ID]);


GO
PRINT N'Creating [dbo].[FK_402774505_402774503]...';


GO
ALTER TABLE [dbo].[T_OGFOGLALTSAGTIPUS] WITH NOCHECK
    ADD CONSTRAINT [FK_402774505_402774503] FOREIGN KEY ([C_ALTANEVID]) REFERENCES [dbo].[T_TANEV] ([ID]);


GO
PRINT N'Creating [dbo].[FK_402599405_402599403]...';


GO
ALTER TABLE [dbo].[T_ORATERV] WITH NOCHECK
    ADD CONSTRAINT [FK_402599405_402599403] FOREIGN KEY ([C_TANEVID]) REFERENCES [dbo].[T_TANEV] ([ID]);


GO
PRINT N'Creating [dbo].[FK_1167105_1167103]...';


GO
ALTER TABLE [dbo].[T_STUDENTCARDTYPE] WITH NOCHECK
    ADD CONSTRAINT [FK_1167105_1167103] FOREIGN KEY ([C_ALTANEVID]) REFERENCES [dbo].[T_TANEV] ([ID]);


GO
PRINT N'Creating [dbo].[FK_402519805_402519803]...';


GO
ALTER TABLE [dbo].[T_FENNTARTOTIPUS] WITH NOCHECK
    ADD CONSTRAINT [FK_402519805_402519803] FOREIGN KEY ([C_ALTANEVID]) REFERENCES [dbo].[T_TANEV] ([ID]);


GO
PRINT N'Creating [dbo].[FK_402628605_402628603]...';


GO
ALTER TABLE [dbo].[T_HELYETTESITESIIDOSZAK] WITH NOCHECK
    ADD CONSTRAINT [FK_402628605_402628603] FOREIGN KEY ([C_TANEVID]) REFERENCES [dbo].[T_TANEV] ([ID]);


GO
PRINT N'Creating [dbo].[FK_402695205_402695203]...';


GO
ALTER TABLE [dbo].[T_PRIORITAS] WITH NOCHECK
    ADD CONSTRAINT [FK_402695205_402695203] FOREIGN KEY ([C_ALTANEVID]) REFERENCES [dbo].[T_TANEV] ([ID]);


GO
PRINT N'Creating [dbo].[FK_402840705_402840703]...';


GO
ALTER TABLE [dbo].[T_KKTANITOVEZGETTSEG] WITH NOCHECK
    ADD CONSTRAINT [FK_402840705_402840703] FOREIGN KEY ([C_TANEVID]) REFERENCES [dbo].[T_TANEV] ([ID]);


GO
PRINT N'Creating [dbo].[FK_402509205_402509203]...';


GO
ALTER TABLE [dbo].[T_MAGANTANULOSAGOKA] WITH NOCHECK
    ADD CONSTRAINT [FK_402509205_402509203] FOREIGN KEY ([C_ALTANEVID]) REFERENCES [dbo].[T_TANEV] ([ID]);


GO
PRINT N'Creating [dbo].[FK_402811205_402811203]...';


GO
ALTER TABLE [dbo].[T_HAZIFELADATOK] WITH NOCHECK
    ADD CONSTRAINT [FK_402811205_402811203] FOREIGN KEY ([C_TANEVID]) REFERENCES [dbo].[T_TANEV] ([ID]);


GO
PRINT N'Creating [dbo].[FK_402539905_402539903]...';


GO
ALTER TABLE [dbo].[T_TANTARGY] WITH NOCHECK
    ADD CONSTRAINT [FK_402539905_402539903] FOREIGN KEY ([C_TANEVID]) REFERENCES [dbo].[T_TANEV] ([ID]);


GO
PRINT N'Creating [dbo].[FK_131202405_131202403]...';


GO
ALTER TABLE [dbo].[T_TRANSACTIONANALYSISFILESTATU] WITH NOCHECK
    ADD CONSTRAINT [FK_131202405_131202403] FOREIGN KEY ([C_ALTANEVID]) REFERENCES [dbo].[T_TANEV] ([ID]);


GO
PRINT N'Creating [dbo].[FK_284754505_284754503]...';


GO
ALTER TABLE [dbo].[T_DIAKIGAZOLVANYIGENYHIBASTATU] WITH NOCHECK
    ADD CONSTRAINT [FK_284754505_284754503] FOREIGN KEY ([C_ALTANEVID]) REFERENCES [dbo].[T_TANEV] ([ID]);


GO
PRINT N'Creating [dbo].[FK_3841605_3841603]...';


GO
ALTER TABLE [dbo].[T_MARITALSTATUS] WITH NOCHECK
    ADD CONSTRAINT [FK_3841605_3841603] FOREIGN KEY ([C_ALTANEVID]) REFERENCES [dbo].[T_TANEV] ([ID]);


GO
PRINT N'Creating [dbo].[FK_402742905_402742903]...';


GO
ALTER TABLE [dbo].[T_IKTESZKOZHASZNALATMOD] WITH NOCHECK
    ADD CONSTRAINT [FK_402742905_402742903] FOREIGN KEY ([C_ALTANEVID]) REFERENCES [dbo].[T_TANEV] ([ID]);


GO
PRINT N'Creating [dbo].[FK_402828705_402828703]...';


GO
ALTER TABLE [dbo].[T_VEGZETTSEG] WITH NOCHECK
    ADD CONSTRAINT [FK_402828705_402828703] FOREIGN KEY ([C_TANEVID]) REFERENCES [dbo].[T_TANEV] ([ID]);


GO
PRINT N'Creating [dbo].[FK_402580105_402580103]...';


GO
ALTER TABLE [dbo].[T_PEDAGOGUSELETPALYAMODELL] WITH NOCHECK
    ADD CONSTRAINT [FK_402580105_402580103] FOREIGN KEY ([C_TANEVID]) REFERENCES [dbo].[T_TANEV] ([ID]);


GO
PRINT N'Creating [dbo].[FK_402774105_402774103]...';


GO
ALTER TABLE [dbo].[T_OGFOGLALKOZAS] WITH NOCHECK
    ADD CONSTRAINT [FK_402774105_402774103] FOREIGN KEY ([C_TANEVID]) REFERENCES [dbo].[T_TANEV] ([ID]);


GO
PRINT N'Creating [dbo].[FK_402599105_402599103]...';


GO
ALTER TABLE [dbo].[T_KIZAROCSOPORTTIPUS] WITH NOCHECK
    ADD CONSTRAINT [FK_402599105_402599103] FOREIGN KEY ([C_ALTANEVID]) REFERENCES [dbo].[T_TANEV] ([ID]);


GO
PRINT N'Creating [dbo].[FK_1109405_1109403]...';


GO
ALTER TABLE [dbo].[T_CIM] WITH NOCHECK
    ADD CONSTRAINT [FK_1109405_1109403] FOREIGN KEY ([C_TANEVID]) REFERENCES [dbo].[T_TANEV] ([ID]);


GO
PRINT N'Creating [dbo].[FK_402519105_402519103]...';


GO
ALTER TABLE [dbo].[T_CSOPORTTIPUS] WITH NOCHECK
    ADD CONSTRAINT [FK_402519105_402519103] FOREIGN KEY ([C_ALTANEVID]) REFERENCES [dbo].[T_TANEV] ([ID]);


GO
PRINT N'Creating [dbo].[FK_402695105_402695103]...';


GO
ALTER TABLE [dbo].[T_FORRAS] WITH NOCHECK
    ADD CONSTRAINT [FK_402695105_402695103] FOREIGN KEY ([C_ALTANEVID]) REFERENCES [dbo].[T_TANEV] ([ID]);


GO
PRINT N'Creating [dbo].[FK_402839405_402839403]...';


GO
ALTER TABLE [dbo].[T_KKVEGZETTSEGTIPUS] WITH NOCHECK
    ADD CONSTRAINT [FK_402839405_402839403] FOREIGN KEY ([C_ALTANEVID]) REFERENCES [dbo].[T_TANEV] ([ID]);


GO
PRINT N'Creating [dbo].[FK_402810805_402810803]...';


GO
ALTER TABLE [dbo].[T_VEGZETTSEGTIPUS] WITH NOCHECK
    ADD CONSTRAINT [FK_402810805_402810803] FOREIGN KEY ([C_ALTANEVID]) REFERENCES [dbo].[T_TANEV] ([ID]);


GO
PRINT N'Creating [dbo].[FK_129125805_129125803]...';


GO
ALTER TABLE [dbo].[T_ORSZAGTIPUS] WITH NOCHECK
    ADD CONSTRAINT [FK_129125805_129125803] FOREIGN KEY ([C_ALTANEVID]) REFERENCES [dbo].[T_TANEV] ([ID]);


GO
PRINT N'Creating [dbo].[FK_284654605_284654603]...';


GO
ALTER TABLE [dbo].[T_DIAKIGAZOLVANYIGENYTIPUS] WITH NOCHECK
    ADD CONSTRAINT [FK_284654605_284654603] FOREIGN KEY ([C_ALTANEVID]) REFERENCES [dbo].[T_TANEV] ([ID]);


GO
PRINT N'Creating [dbo].[FK_3840805_3840803]...';


GO
ALTER TABLE [dbo].[T_IMPOSITIONSTATUS] WITH NOCHECK
    ADD CONSTRAINT [FK_3840805_3840803] FOREIGN KEY ([C_ALTANEVID]) REFERENCES [dbo].[T_TANEV] ([ID]);


GO
PRINT N'Creating [dbo].[FK_402557405_402557403]...';


GO
ALTER TABLE [dbo].[T_HELYETTESITESTIPUS] WITH NOCHECK
    ADD CONSTRAINT [FK_402557405_402557403] FOREIGN KEY ([C_ALTANEVID]) REFERENCES [dbo].[T_TANEV] ([ID]);


GO
PRINT N'Creating [dbo].[FK_402742805_402742803]...';


GO
ALTER TABLE [dbo].[T_ELSODLEGESIKTESZKOZ] WITH NOCHECK
    ADD CONSTRAINT [FK_402742805_402742803] FOREIGN KEY ([C_ALTANEVID]) REFERENCES [dbo].[T_TANEV] ([ID]);


GO
PRINT N'Creating [dbo].[FK_402827105_402827103]...';


GO
ALTER TABLE [dbo].[T_TANULOHAZIFELADAT] WITH NOCHECK
    ADD CONSTRAINT [FK_402827105_402827103] FOREIGN KEY ([C_TANEVID]) REFERENCES [dbo].[T_TANEV] ([ID]);


GO
PRINT N'Creating [dbo].[FK_402580005_402580003]...';


GO
ALTER TABLE [dbo].[T_ELETPALYAMODELLFOKOZATTIPUS] WITH NOCHECK
    ADD CONSTRAINT [FK_402580005_402580003] FOREIGN KEY ([C_ALTANEVID]) REFERENCES [dbo].[T_TANEV] ([ID]);


GO
PRINT N'Creating [dbo].[FK_402773605_402773603]...';


GO
ALTER TABLE [dbo].[T_OGTANTARGYFOGLALTSAG] WITH NOCHECK
    ADD CONSTRAINT [FK_402773605_402773603] FOREIGN KEY ([C_TANEVID]) REFERENCES [dbo].[T_TANEV] ([ID]);


GO
PRINT N'Creating [dbo].[FK_402596205_402596203]...';


GO
ALTER TABLE [dbo].[T_FELHASZNALOERTESITESBEALLITA] WITH NOCHECK
    ADD CONSTRAINT [FK_402596205_402596203] FOREIGN KEY ([C_TANEVID]) REFERENCES [dbo].[T_TANEV] ([ID]);


GO
PRINT N'Creating [dbo].[FK_1073505_1073503]...';


GO
ALTER TABLE [dbo].[T_TRANSACTION] WITH NOCHECK
    ADD CONSTRAINT [FK_1073505_1073503] FOREIGN KEY ([C_TANEVID]) REFERENCES [dbo].[T_TANEV] ([ID]);


GO
PRINT N'Creating [dbo].[FK_402517905_402517903]...';


GO
ALTER TABLE [dbo].[T_ROKONSAGIFOK] WITH NOCHECK
    ADD CONSTRAINT [FK_402517905_402517903] FOREIGN KEY ([C_ALTANEVID]) REFERENCES [dbo].[T_TANEV] ([ID]);


GO
PRINT N'Creating [dbo].[FK_402539205_402539203]...';


GO
ALTER TABLE [dbo].[T_TANTERV] WITH NOCHECK
    ADD CONSTRAINT [FK_402539205_402539203] FOREIGN KEY ([C_TANEVID]) REFERENCES [dbo].[T_TANEV] ([ID]);


GO
PRINT N'Creating [dbo].[FK_402670905_402670903]...';


GO
ALTER TABLE [dbo].[T_SZERZODOSZEMELYPOZICIO] WITH NOCHECK
    ADD CONSTRAINT [FK_402670905_402670903] FOREIGN KEY ([C_ALTANEVID]) REFERENCES [dbo].[T_TANEV] ([ID]);


GO
PRINT N'Creating [dbo].[FK_402839305_402839303]...';


GO
ALTER TABLE [dbo].[T_KKAMINEPZENETIPUS] WITH NOCHECK
    ADD CONSTRAINT [FK_402839305_402839303] FOREIGN KEY ([C_ALTANEVID]) REFERENCES [dbo].[T_TANEV] ([ID]);


GO
PRINT N'Creating [dbo].[FK_402508005_402508003]...';


GO
ALTER TABLE [dbo].[T_ENTITYATTRIBUTEHISTORY] WITH NOCHECK
    ADD CONSTRAINT [FK_402508005_402508003] FOREIGN KEY ([C_TANEVID]) REFERENCES [dbo].[T_TANEV] ([ID]);


GO
PRINT N'Creating [dbo].[FK_402809805_402809803]...';


GO
ALTER TABLE [dbo].[T_ELEARNING] WITH NOCHECK
    ADD CONSTRAINT [FK_402809805_402809803] FOREIGN KEY ([C_TANEVID]) REFERENCES [dbo].[T_TANEV] ([ID]);


GO
PRINT N'Creating [dbo].[FK_125783105_125783103]...';


GO
ALTER TABLE [dbo].[T_USERNOTIFICATION] WITH NOCHECK
    ADD CONSTRAINT [FK_125783105_125783103] FOREIGN KEY ([C_TANEVID]) REFERENCES [dbo].[T_TANEV] ([ID]);


GO
PRINT N'Creating [dbo].[FK_276170205_276170203]...';


GO
ALTER TABLE [dbo].[T_IMPOSITIONIMPOSITIONGROUP] WITH NOCHECK
    ADD CONSTRAINT [FK_276170205_276170203] FOREIGN KEY ([C_TANEVID]) REFERENCES [dbo].[T_TANEV] ([ID]);


GO
PRINT N'Creating [dbo].[FK_3839205_3839203]...';


GO
ALTER TABLE [dbo].[T_LANGUAGE] WITH NOCHECK
    ADD CONSTRAINT [FK_3839205_3839203] FOREIGN KEY ([C_ALTANEVID]) REFERENCES [dbo].[T_TANEV] ([ID]);


GO
PRINT N'Creating [dbo].[FK_402556205_402556203]...';


GO
ALTER TABLE [dbo].[T_NAPTARINAP] WITH NOCHECK
    ADD CONSTRAINT [FK_402556205_402556203] FOREIGN KEY ([C_TANEVID]) REFERENCES [dbo].[T_TANEV] ([ID]);


GO
PRINT N'Creating [dbo].[FK_402742405_402742403]...';


GO
ALTER TABLE [dbo].[T_PEDAGOGUSIKTADATSZOLGALTATAS] WITH NOCHECK
    ADD CONSTRAINT [FK_402742405_402742403] FOREIGN KEY ([C_TANEVID]) REFERENCES [dbo].[T_TANEV] ([ID]);


GO
PRINT N'Creating [dbo].[FK_402579905_402579903]...';


GO
ALTER TABLE [dbo].[T_ELETPALYAMODELLSTATUSZOK] WITH NOCHECK
    ADD CONSTRAINT [FK_402579905_402579903] FOREIGN KEY ([C_ALTANEVID]) REFERENCES [dbo].[T_TANEV] ([ID]);


GO
PRINT N'Creating [dbo].[FK_402595705_402595703]...';


GO
ALTER TABLE [dbo].[T_TANARIATLAGSULY] WITH NOCHECK
    ADD CONSTRAINT [FK_402595705_402595703] FOREIGN KEY ([C_TANEVID]) REFERENCES [dbo].[T_TANEV] ([ID]);


GO
PRINT N'Creating [dbo].[FK_402621205_402621203]...';


GO
ALTER TABLE [dbo].[T_IKTATOTTDOKUMENTUMOK] WITH NOCHECK
    ADD CONSTRAINT [FK_402621205_402621203] FOREIGN KEY ([C_TANEVID]) REFERENCES [dbo].[T_TANEV] ([ID]);


GO
PRINT N'Creating [dbo].[FK_402825705_402825703]...';


GO
ALTER TABLE [dbo].[T_UZENETCIMZETT] WITH NOCHECK
    ADD CONSTRAINT [FK_402825705_402825703] FOREIGN KEY ([C_TANEVID]) REFERENCES [dbo].[T_TANEV] ([ID]);


GO
PRINT N'Creating [dbo].[FK_402773405_402773403]...';


GO
ALTER TABLE [dbo].[T_OGFOGLALKOZAS_TEREM] WITH NOCHECK
    ADD CONSTRAINT [FK_402773405_402773403] FOREIGN KEY ([C_TANEVID]) REFERENCES [dbo].[T_TANEV] ([ID]);


GO
PRINT N'Creating [dbo].[FK_4026237_4026236]...';


GO
ALTER TABLE [dbo].[T_TANULO] WITH NOCHECK
    ADD CONSTRAINT [FK_4026237_4026236] FOREIGN KEY ([C_FELVETELTANEVEID]) REFERENCES [dbo].[T_TANEV] ([ID]);


GO
PRINT N'Creating [dbo].[FK_402517805_402517803]...';


GO
ALTER TABLE [dbo].[T_TANULO] WITH NOCHECK
    ADD CONSTRAINT [FK_402517805_402517803] FOREIGN KEY ([C_ALTANEVID]) REFERENCES [dbo].[T_TANEV] ([ID]);


GO
PRINT N'Creating [dbo].[FK_402670805_402670803]...';


GO
ALTER TABLE [dbo].[T_ENAPLOTIPUS] WITH NOCHECK
    ADD CONSTRAINT [FK_402670805_402670803] FOREIGN KEY ([C_ALTANEVID]) REFERENCES [dbo].[T_TANEV] ([ID]);


GO
PRINT N'Creating [dbo].[FK_402839205_402839203]...';


GO
ALTER TABLE [dbo].[T_KKAMIELEKTROAKUTIPUS] WITH NOCHECK
    ADD CONSTRAINT [FK_402839205_402839203] FOREIGN KEY ([C_ALTANEVID]) REFERENCES [dbo].[T_TANEV] ([ID]);


GO
PRINT N'Creating [dbo].[FK_402504305_402504303]...';


GO
ALTER TABLE [dbo].[T_ENTITYHISTORY] WITH NOCHECK
    ADD CONSTRAINT [FK_402504305_402504303] FOREIGN KEY ([C_TANEVID]) REFERENCES [dbo].[T_TANEV] ([ID]);


GO
PRINT N'Creating [dbo].[FK_402537605_402537603]...';


GO
ALTER TABLE [dbo].[T_OKTATASINEVELESIFELADAT] WITH NOCHECK
    ADD CONSTRAINT [FK_402537605_402537603] FOREIGN KEY ([C_ALTANEVID]) REFERENCES [dbo].[T_TANEV] ([ID]);


GO
PRINT N'Creating [dbo].[FK_274081905_274081903]...';


GO
ALTER TABLE [dbo].[T_SYSTEMPARAMETERTYPE] WITH NOCHECK
    ADD CONSTRAINT [FK_274081905_274081903] FOREIGN KEY ([C_ALTANEVID]) REFERENCES [dbo].[T_TANEV] ([ID]);


GO
PRINT N'Creating [dbo].[FK_1068505_1068503]...';


GO
ALTER TABLE [dbo].[T_PARTNER] WITH NOCHECK
    ADD CONSTRAINT [FK_1068505_1068503] FOREIGN KEY ([C_TANEVID]) REFERENCES [dbo].[T_TANEV] ([ID]);


GO
PRINT N'Creating [dbo].[FK_3836905_3836903]...';


GO
ALTER TABLE [dbo].[T_CIMTIPUS] WITH NOCHECK
    ADD CONSTRAINT [FK_3836905_3836903] FOREIGN KEY ([C_ALTANEVID]) REFERENCES [dbo].[T_TANEV] ([ID]);


GO
PRINT N'Creating [dbo].[FK_402742305_402742303]...';


GO
ALTER TABLE [dbo].[T_WIFIELERES] WITH NOCHECK
    ADD CONSTRAINT [FK_402742305_402742303] FOREIGN KEY ([C_ALTANEVID]) REFERENCES [dbo].[T_TANEV] ([ID]);


GO
PRINT N'Creating [dbo].[FK_402808305_402808303]...';


GO
ALTER TABLE [dbo].[T_DICTIONARYTYPE] WITH NOCHECK
    ADD CONSTRAINT [FK_402808305_402808303] FOREIGN KEY ([C_TANEVID]) REFERENCES [dbo].[T_TANEV] ([ID]);


GO
PRINT N'Creating [dbo].[FK_402555605_402555603]...';


GO
ALTER TABLE [dbo].[T_TANMENET] WITH NOCHECK
    ADD CONSTRAINT [FK_402555605_402555603] FOREIGN KEY ([C_TANEVID]) REFERENCES [dbo].[T_TANEV] ([ID]);


GO
PRINT N'Creating [dbo].[FK_402579705_402579703]...';


GO
ALTER TABLE [dbo].[T_ESEMENYZARADEKTIPUS] WITH NOCHECK
    ADD CONSTRAINT [FK_402579705_402579703] FOREIGN KEY ([C_ALTANEVID]) REFERENCES [dbo].[T_TANEV] ([ID]);


GO
PRINT N'Creating [dbo].[FK_402594005_402594003]...';


GO
ALTER TABLE [dbo].[T_TANARITANTARGY] WITH NOCHECK
    ADD CONSTRAINT [FK_402594005_402594003] FOREIGN KEY ([C_TANEVID]) REFERENCES [dbo].[T_TANEV] ([ID]);


GO
PRINT N'Creating [dbo].[FK_402619105_402619103]...';


GO
ALTER TABLE [dbo].[T_JOGOSULTSAG] WITH NOCHECK
    ADD CONSTRAINT [FK_402619105_402619103] FOREIGN KEY ([C_TANEVID]) REFERENCES [dbo].[T_TANEV] ([ID]);


GO
PRINT N'Creating [dbo].[FK_125763105_125763103]...';


GO
ALTER TABLE [dbo].[T_ESEMENYSTATUSZ] WITH NOCHECK
    ADD CONSTRAINT [FK_125763105_125763103] FOREIGN KEY ([C_ALTANEVID]) REFERENCES [dbo].[T_TANEV] ([ID]);


GO
PRINT N'Creating [dbo].[FK_402670705_402670703]...';


GO
ALTER TABLE [dbo].[T_ENAPLOFORRAS] WITH NOCHECK
    ADD CONSTRAINT [FK_402670705_402670703] FOREIGN KEY ([C_ALTANEVID]) REFERENCES [dbo].[T_TANEV] ([ID]);


GO
PRINT N'Creating [dbo].[FK_402839105_402839103]...';


GO
ALTER TABLE [dbo].[T_KKAMIVEGZETTSEGTIPUS] WITH NOCHECK
    ADD CONSTRAINT [FK_402839105_402839103] FOREIGN KEY ([C_ALTANEVID]) REFERENCES [dbo].[T_TANEV] ([ID]);


GO
PRINT N'Creating [dbo].[FK_402773005_402773003]...';


GO
ALTER TABLE [dbo].[T_OGOSZTALYCSOPORT] WITH NOCHECK
    ADD CONSTRAINT [FK_402773005_402773003] FOREIGN KEY ([C_TANEVID]) REFERENCES [dbo].[T_TANEV] ([ID]);


GO
PRINT N'Creating [dbo].[FK_402502205_402502203]...';


GO
ALTER TABLE [dbo].[T_FELHASZNALOBELEPES] WITH NOCHECK
    ADD CONSTRAINT [FK_402502205_402502203] FOREIGN KEY ([C_TANEVID]) REFERENCES [dbo].[T_TANEV] ([ID]);


GO
PRINT N'Creating [dbo].[FK_402825605_402825603]...';


GO
ALTER TABLE [dbo].[T_UZENETJOGKORTIPUS] WITH NOCHECK
    ADD CONSTRAINT [FK_402825605_402825603] FOREIGN KEY ([C_ALTANEVID]) REFERENCES [dbo].[T_TANEV] ([ID]);


GO
PRINT N'Creating [dbo].[FK_402537205_402537203]...';


GO
ALTER TABLE [dbo].[T_ERTELMIFOGYATEKOSTIPUS] WITH NOCHECK
    ADD CONSTRAINT [FK_402537205_402537203] FOREIGN KEY ([C_ALTANEVID]) REFERENCES [dbo].[T_TANEV] ([ID]);


GO
PRINT N'Creating [dbo].[FK_265686405_265686403]...';


GO
ALTER TABLE [dbo].[T_ONLINEUSER] WITH NOCHECK
    ADD CONSTRAINT [FK_265686405_265686403] FOREIGN KEY ([C_TANEVID]) REFERENCES [dbo].[T_TANEV] ([ID]);


GO
PRINT N'Creating [dbo].[FK_3833005_3833003]...';


GO
ALTER TABLE [dbo].[T_NEM] WITH NOCHECK
    ADD CONSTRAINT [FK_3833005_3833003] FOREIGN KEY ([C_ALTANEVID]) REFERENCES [dbo].[T_TANEV] ([ID]);


GO
PRINT N'Creating [dbo].[FK_402742205_402742203]...';


GO
ALTER TABLE [dbo].[T_IKTKOMPETENCIASZINT] WITH NOCHECK
    ADD CONSTRAINT [FK_402742205_402742203] FOREIGN KEY ([C_ALTANEVID]) REFERENCES [dbo].[T_TANEV] ([ID]);


GO
PRINT N'Creating [dbo].[FK_402553005_402553003]...';


GO
ALTER TABLE [dbo].[T_ORARENDIORA] WITH NOCHECK
    ADD CONSTRAINT [FK_402553005_402553003] FOREIGN KEY ([C_TANEVID]) REFERENCES [dbo].[T_TANEV] ([ID]);


GO
PRINT N'Creating [dbo].[FK_402576905_402576903]...';


GO
ALTER TABLE [dbo].[T_TANULOMENTESSEG] WITH NOCHECK
    ADD CONSTRAINT [FK_402576905_402576903] FOREIGN KEY ([C_TANEVID]) REFERENCES [dbo].[T_TANEV] ([ID]);


GO
PRINT N'Creating [dbo].[FK_402592805_402592803]...';


GO
ALTER TABLE [dbo].[T_ERTESITESGENERALASTORTENET] WITH NOCHECK
    ADD CONSTRAINT [FK_402592805_402592803] FOREIGN KEY ([C_TANEVID]) REFERENCES [dbo].[T_TANEV] ([ID]);


GO
PRINT N'Creating [dbo].[FK_1047705_1047703]...';


GO
ALTER TABLE [dbo].[T_ERRORTYPE] WITH NOCHECK
    ADD CONSTRAINT [FK_1047705_1047703] FOREIGN KEY ([C_ALTANEVID]) REFERENCES [dbo].[T_TANEV] ([ID]);


GO
PRINT N'Creating [dbo].[FK_402618905_402618903]...';


GO
ALTER TABLE [dbo].[T_SZEREPKORTIPUS] WITH NOCHECK
    ADD CONSTRAINT [FK_402618905_402618903] FOREIGN KEY ([C_ALTANEVID]) REFERENCES [dbo].[T_TANEV] ([ID]);


GO
PRINT N'Creating [dbo].[FK_102945805_102945803]...';


GO
ALTER TABLE [dbo].[T_TRANSACTIONSTATUS] WITH NOCHECK
    ADD CONSTRAINT [FK_102945805_102945803] FOREIGN KEY ([C_ALTANEVID]) REFERENCES [dbo].[T_TANEV] ([ID]);


GO
PRINT N'Creating [dbo].[FK_402805005_402805003]...';


GO
ALTER TABLE [dbo].[T_TANULOERTEKELESLATTAMOZAS] WITH NOCHECK
    ADD CONSTRAINT [FK_402805005_402805003] FOREIGN KEY ([C_TANEVID]) REFERENCES [dbo].[T_TANEV] ([ID]);


GO
PRINT N'Creating [dbo].[FK_402669405_402669403]...';


GO
ALTER TABLE [dbo].[T_ADATSZOLGALTATASENAPLO] WITH NOCHECK
    ADD CONSTRAINT [FK_402669405_402669403] FOREIGN KEY ([C_TANEVID]) REFERENCES [dbo].[T_TANEV] ([ID]);


GO
PRINT N'Creating [dbo].[FK_402839005_402839003]...';


GO
ALTER TABLE [dbo].[T_KKAMITERULETTIPUS] WITH NOCHECK
    ADD CONSTRAINT [FK_402839005_402839003] FOREIGN KEY ([C_ALTANEVID]) REFERENCES [dbo].[T_TANEV] ([ID]);


GO
PRINT N'Creating [dbo].[FK_402824805_402824803]...';


GO
ALTER TABLE [dbo].[T_UZENET] WITH NOCHECK
    ADD CONSTRAINT [FK_402824805_402824803] FOREIGN KEY ([C_TANEVID]) REFERENCES [dbo].[T_TANEV] ([ID]);


GO
PRINT N'Creating [dbo].[FK_402537105_402537103]...';


GO
ALTER TABLE [dbo].[T_HALLASSERULTTIPUS] WITH NOCHECK
    ADD CONSTRAINT [FK_402537105_402537103] FOREIGN KEY ([C_ALTANEVID]) REFERENCES [dbo].[T_TANEV] ([ID]);


GO
PRINT N'Creating [dbo].[FK_261224905_261224903]...';


GO
ALTER TABLE [dbo].[T_LOGINLINKS] WITH NOCHECK
    ADD CONSTRAINT [FK_261224905_261224903] FOREIGN KEY ([C_TANEVID]) REFERENCES [dbo].[T_TANEV] ([ID]);


GO
PRINT N'Creating [dbo].[FK_2552905_2552903]...';


GO
ALTER TABLE [dbo].[T_BANKACCOUNT] WITH NOCHECK
    ADD CONSTRAINT [FK_2552905_2552903] FOREIGN KEY ([C_TANEVID]) REFERENCES [dbo].[T_TANEV] ([ID]);


GO
PRINT N'Creating [dbo].[FK_402772905_402772903]...';


GO
ALTER TABLE [dbo].[T_OGTEREM_TANTARGY] WITH NOCHECK
    ADD CONSTRAINT [FK_402772905_402772903] FOREIGN KEY ([C_TANEVID]) REFERENCES [dbo].[T_TANEV] ([ID]);


GO
PRINT N'Creating [dbo].[FK_402564102_402564100]...';


GO
ALTER TABLE [dbo].[T_TANULOERTEKELES] WITH NOCHECK
    ADD CONSTRAINT [FK_402564102_402564100] FOREIGN KEY ([C_INTEZMENYID]) REFERENCES [dbo].[T_INTEZMENY] ([ID]);


GO
PRINT N'Creating [dbo].[FK_4025641_4025644]...';


GO
ALTER TABLE [dbo].[T_TANULOERTEKELES] WITH NOCHECK
    ADD CONSTRAINT [FK_4025641_4025644] FOREIGN KEY ([C_TIPUSID], [C_INTEZMENYID], [C_TANEVID]) REFERENCES [dbo].[T_ERTEKELESTIPUS] ([ID], [C_ALINTEZMENYID], [C_ALTANEVID]);


GO
PRINT N'Creating [dbo].[FK_4025641_4026317]...';


GO
ALTER TABLE [dbo].[T_TANULOERTEKELES] WITH NOCHECK
    ADD CONSTRAINT [FK_4025641_4026317] FOREIGN KEY ([C_ERTEKELESOSZTALYZATID], [C_INTEZMENYID], [C_TANEVID]) REFERENCES [dbo].[T_OSZTALYZATTIPUS] ([ID], [C_ALINTEZMENYID], [C_ALTANEVID]);


GO
PRINT N'Creating [dbo].[FK_4025641_4028206]...';


GO
ALTER TABLE [dbo].[T_TANULOERTEKELES] WITH NOCHECK
    ADD CONSTRAINT [FK_4025641_4028206] FOREIGN KEY ([C_ERTEKELESMODID], [C_INTEZMENYID], [C_TANEVID]) REFERENCES [dbo].[T_ERTEKELESMOD] ([ID], [C_ALINTEZMENYID], [C_ALTANEVID]);


GO
PRINT N'Creating [dbo].[FK_4025641_4028210]...';


GO
ALTER TABLE [dbo].[T_TANULOERTEKELES] WITH NOCHECK
    ADD CONSTRAINT [FK_4025641_4028210] FOREIGN KEY ([C_MAGATARTASERTEKID], [C_INTEZMENYID], [C_TANEVID]) REFERENCES [dbo].[T_MAGATARTASERTEKELESTIPUS] ([ID], [C_ALINTEZMENYID], [C_ALTANEVID]);


GO
PRINT N'Creating [dbo].[FK_4025641_4028211]...';


GO
ALTER TABLE [dbo].[T_TANULOERTEKELES] WITH NOCHECK
    ADD CONSTRAINT [FK_4025641_4028211] FOREIGN KEY ([C_MAGATARTASOSZTALYZATID], [C_INTEZMENYID], [C_TANEVID]) REFERENCES [dbo].[T_OSZTALYZATTIPUS] ([ID], [C_ALINTEZMENYID], [C_ALTANEVID]);


GO
PRINT N'Creating [dbo].[FK_4025641_4028214]...';


GO
ALTER TABLE [dbo].[T_TANULOERTEKELES] WITH NOCHECK
    ADD CONSTRAINT [FK_4025641_4028214] FOREIGN KEY ([C_SZORGALOMERTEKID], [C_INTEZMENYID], [C_TANEVID]) REFERENCES [dbo].[T_SZORGALOMERTEKELESTIPUS] ([ID], [C_ALINTEZMENYID], [C_ALTANEVID]);


GO
PRINT N'Creating [dbo].[FK_4025641_4028215]...';


GO
ALTER TABLE [dbo].[T_TANULOERTEKELES] WITH NOCHECK
    ADD CONSTRAINT [FK_4025641_4028215] FOREIGN KEY ([C_SZORGALOMOSZTALYZATID], [C_INTEZMENYID], [C_TANEVID]) REFERENCES [dbo].[T_OSZTALYZATTIPUS] ([ID], [C_ALINTEZMENYID], [C_ALTANEVID]);


GO
PRINT N'Creating [dbo].[FK_4025662_4025660]...';


GO
ALTER TABLE [dbo].[T_TANULOERTEKELES] WITH NOCHECK
    ADD CONSTRAINT [FK_4025662_4025660] FOREIGN KEY ([C_TANTARGYID]) REFERENCES [dbo].[T_TANTARGY] ([ID]);


GO
PRINT N'Creating [dbo].[FK_4025665_4025663]...';


GO
ALTER TABLE [dbo].[T_TANULOERTEKELES] WITH NOCHECK
    ADD CONSTRAINT [FK_4025665_4025663] FOREIGN KEY ([C_TANULOID]) REFERENCES [dbo].[T_TANULO] ([ID]);


GO
PRINT N'Creating [dbo].[FK_4025668_4025666]...';


GO
ALTER TABLE [dbo].[T_TANULOERTEKELES] WITH NOCHECK
    ADD CONSTRAINT [FK_4025668_4025666] FOREIGN KEY ([C_OSZTALYCSOPORTID]) REFERENCES [dbo].[T_OSZTALYCSOPORT] ([ID]);


GO
PRINT N'Creating [dbo].[FK_4025670_4025669]...';


GO
ALTER TABLE [dbo].[T_TANULOERTEKELES] WITH NOCHECK
    ADD CONSTRAINT [FK_4025670_4025669] FOREIGN KEY ([C_ERTEKELOID]) REFERENCES [dbo].[T_ALKALMAZOTT] ([ID]);


GO
PRINT N'Creating [dbo].[FK_4025938_4025937]...';


GO
ALTER TABLE [dbo].[T_TANULOERTEKELES] WITH NOCHECK
    ADD CONSTRAINT [FK_4025938_4025937] FOREIGN KEY ([C_TANORAID]) REFERENCES [dbo].[T_TANITASIORA] ([ID]);


GO
PRINT N'Creating [dbo].[FK_4028462_4028461]...';


GO
ALTER TABLE [dbo].[T_TANULOERTEKELES] WITH NOCHECK
    ADD CONSTRAINT [FK_4028462_4028461] FOREIGN KEY ([C_ROGZITESKORITANULOOSZTALYID]) REFERENCES [dbo].[T_OSZTALYCSOPORT] ([ID]);


GO
PRINT N'Creating [dbo].[FK_4028054_4028052]...';


GO
ALTER TABLE [dbo].[T_TANULOERTEKELESLATTAMOZAS] WITH NOCHECK
    ADD CONSTRAINT [FK_4028054_4028052] FOREIGN KEY ([C_TANULOERTEKELESID]) REFERENCES [dbo].[T_TANULOERTEKELES] ([ID]);


GO
PRINT N'Creating [dbo].[FK_4028380_4028379]...';


GO
ALTER TABLE [dbo].[T_TANULOERTEKELES] WITH NOCHECK
    ADD CONSTRAINT [FK_4028380_4028379] FOREIGN KEY ([C_OSSZEFUGGOSZAKGYAKID]) REFERENCES [dbo].[T_OSSZEFUGGOSZAKGYAK] ([ID]);


GO
PRINT N'Refreshing [dbo].[T_OSSZEFUGGOSZAKGYAK_OSSZES]...';


GO
EXECUTE sp_refreshsqlmodule N'[dbo].[T_OSSZEFUGGOSZAKGYAK_OSSZES]';


GO
PRINT N'Refreshing [dbo].[T_OSZTALY_OSSZES]...';


GO
EXECUTE sp_refreshsqlmodule N'[dbo].[T_OSZTALY_OSSZES]';


GO
PRINT N'Refreshing [dbo].[T_TANEV_OSSZES]...';


GO
EXECUTE sp_refreshsqlmodule N'[dbo].[T_TANEV_OSSZES]';


GO
PRINT N'Refreshing [dbo].[T_TANULOERTEKELES_OSSZES]...';


GO
EXECUTE sp_refreshsqlmodule N'[dbo].[T_TANULOERTEKELES_OSSZES]';


GO
PRINT N'Refreshing [dbo].[fnGetDokumentumOsztalyokTanevenkent]...';


GO
EXECUTE sp_refreshsqlmodule N'[dbo].[fnGetDokumentumOsztalyokTanevenkent]';


GO
PRINT N'Refreshing [dbo].[fnGetLemorzsolodottTanulokByFelhely]...';


GO
EXECUTE sp_refreshsqlmodule N'[dbo].[fnGetLemorzsolodottTanulokByFelhely]';


GO
PRINT N'Refreshing [dbo].[fnGetDokumentumErtekelesekOsztalyonkent]...';


GO
EXECUTE sp_refreshsqlmodule N'[dbo].[fnGetDokumentumErtekelesekOsztalyonkent]';


GO
PRINT N'Refreshing [dbo].[fnGetDokumentumTanulokEvesOraszamaiOsztalynkonet]...';


GO
EXECUTE sp_refreshsqlmodule N'[dbo].[fnGetDokumentumTanulokEvesOraszamaiOsztalynkonet]';


GO
PRINT N'Refreshing [dbo].[fnGetKopcsolodoOsztalyCsoportokByDateRange]...';


GO
EXECUTE sp_refreshsqlmodule N'[dbo].[fnGetKopcsolodoOsztalyCsoportokByDateRange]';


GO
PRINT N'Refreshing [dbo].[fnGetTanuloOsztaly]...';


GO
EXECUTE sp_refreshsqlmodule N'[dbo].[fnGetTanuloOsztaly]';


GO
PRINT N'Refreshing [dbo].[fnGetDokumentumErtekelesekMuveszetiOktatasbanOsztalyonkent]...';


GO
EXECUTE sp_refreshsqlmodule N'[dbo].[fnGetDokumentumErtekelesekMuveszetiOktatasbanOsztalyonkent]';


GO
PRINT N'Refreshing [dbo].[fnGetTanorak]...';


GO
EXECUTE sp_refreshsqlmodule N'[dbo].[fnGetTanorak]';


GO
PRINT N'Refreshing [dbo].[sp_Global_GetDatabaseErrors]...';


GO
EXECUTE sp_refreshsqlmodule N'[dbo].[sp_Global_GetDatabaseErrors]';


GO
PRINT N'Refreshing [dbo].[sp_Global_SetSystemSettingsDefaultData]...';


GO
EXECUTE sp_refreshsqlmodule N'[dbo].[sp_Global_SetSystemSettingsDefaultData]';


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_OSSZEFUGGOSZAKGYAK] WITH CHECK CHECK CONSTRAINT [FK_4028372_4028370];

ALTER TABLE [dbo].[T_OSSZEFUGGOSZAKGYAK] WITH CHECK CHECK CONSTRAINT [FK_4028375_4028373];

ALTER TABLE [dbo].[T_OSSZEFUGGOSZAKGYAK] WITH CHECK CHECK CONSTRAINT [FK_4028378_4028376];

ALTER TABLE [dbo].[T_OSSZEFUGGOSZAKGYAK] WITH CHECK CHECK CONSTRAINT [FK_402836302_402836300];

ALTER TABLE [dbo].[T_OSSZEFUGGOSZAKGYAK] WITH CHECK CHECK CONSTRAINT [FK_402836305_402836303];

ALTER TABLE [dbo].[T_NAPLOELLENORZES] WITH CHECK CHECK CONSTRAINT [FK_4025763_4025762];

ALTER TABLE [dbo].[T_OSZTALY] WITH CHECK CHECK CONSTRAINT [FK_T_4025296_4025338];

ALTER TABLE [dbo].[T_OSZTALY] WITH CHECK CHECK CONSTRAINT [FK_4025320_4025319];

ALTER TABLE [dbo].[T_OSZTALY] WITH CHECK CHECK CONSTRAINT [FK_4025323_4025322];

ALTER TABLE [dbo].[T_OSZTALY] WITH CHECK CHECK CONSTRAINT [FK_4025421_4025419];

ALTER TABLE [dbo].[T_OSZTALY] WITH CHECK CHECK CONSTRAINT [FK_402529402_402529400];

ALTER TABLE [dbo].[T_OSZTALY] WITH CHECK CHECK CONSTRAINT [FK_402529405_402529403];

ALTER TABLE [dbo].[T_OSZTALY] WITH CHECK CHECK CONSTRAINT [FK_4025294_4025295];

ALTER TABLE [dbo].[T_OSZTALY] WITH CHECK CHECK CONSTRAINT [FK_4025294_4027544];

ALTER TABLE [dbo].[T_OSZTALY] WITH CHECK CHECK CONSTRAINT [FK_4025294_4027545];

ALTER TABLE [dbo].[T_OSZTALY] WITH CHECK CHECK CONSTRAINT [FK_4025294_4027546];

ALTER TABLE [dbo].[T_OSZTALY] WITH CHECK CHECK CONSTRAINT [FK_4025294_4027547];

ALTER TABLE [dbo].[T_OSZTALY] WITH CHECK CHECK CONSTRAINT [FK_4025294_4028299];

ALTER TABLE [dbo].[T_CSOPORT] WITH CHECK CHECK CONSTRAINT [FK_4026206_4026204];

ALTER TABLE [dbo].[T_CSOPORTOK_OSZTALYOK] WITH CHECK CHECK CONSTRAINT [FK_4025318_4025316];

ALTER TABLE [dbo].[T_ENAPLOHASZNALAT] WITH CHECK CHECK CONSTRAINT [FK_402742005_402742003];

ALTER TABLE [dbo].[T_NAPLOELLENORZES] WITH CHECK CHECK CONSTRAINT [FK_402575205_402575203];

ALTER TABLE [dbo].[T_MESSAGESTATUS] WITH CHECK CHECK CONSTRAINT [FK_402592605_402592603];

ALTER TABLE [dbo].[T_EMAIL] WITH CHECK CHECK CONSTRAINT [FK_987605_987603];

ALTER TABLE [dbo].[T_TANULOKOZOSSEGISZOLGALAT] WITH CHECK CHECK CONSTRAINT [FK_402617205_402617203];

ALTER TABLE [dbo].[T_SCSTUDENTTEMPORARYCARD] WITH CHECK CHECK CONSTRAINT [FK_99084705_99084703];

ALTER TABLE [dbo].[T_TANULOESEMENYLATTAMOZAS] WITH CHECK CHECK CONSTRAINT [FK_402804805_402804803];

ALTER TABLE [dbo].[T_ENAPLOINFRA] WITH CHECK CHECK CONSTRAINT [FK_402669305_402669303];

ALTER TABLE [dbo].[T_KKAMIJAZZZENETIPUS] WITH CHECK CHECK CONSTRAINT [FK_402838905_402838903];

ALTER TABLE [dbo].[T_GONDVISELO] WITH CHECK CHECK CONSTRAINT [FK_402516905_402516903];

ALTER TABLE [dbo].[T_LATASSERULTTIPUS] WITH CHECK CHECK CONSTRAINT [FK_402537005_402537003];

ALTER TABLE [dbo].[T_LOG] WITH CHECK CHECK CONSTRAINT [FK_402497605_402497603];

ALTER TABLE [dbo].[T_UZENETJOGOK] WITH CHECK CHECK CONSTRAINT [FK_402824405_402824403];

ALTER TABLE [dbo].[T_OGTANARFOGLALTSAG] WITH CHECK CHECK CONSTRAINT [FK_402772405_402772403];

ALTER TABLE [dbo].[T_TAGOZATTIPUS] WITH CHECK CHECK CONSTRAINT [FK_402739605_402739603];

ALTER TABLE [dbo].[T_LOGINNEWS] WITH CHECK CHECK CONSTRAINT [FK_261034805_261034803];

ALTER TABLE [dbo].[T_IGAZOLAS] WITH CHECK CHECK CONSTRAINT [FK_402574605_402574603];

ALTER TABLE [dbo].[T_PARTFILLSTATUS] WITH CHECK CHECK CONSTRAINT [FK_402616205_402616203];

ALTER TABLE [dbo].[T_CREDITCARDPAYMENT] WITH CHECK CHECK CONSTRAINT [FK_2294205_2294203];

ALTER TABLE [dbo].[T_SCAPPLICATIONFORMBATCH] WITH CHECK CHECK CONSTRAINT [FK_99079205_99079203];

ALTER TABLE [dbo].[T_TANULOMULASZTASLATTAMOZAS] WITH CHECK CHECK CONSTRAINT [FK_402804605_402804603];

ALTER TABLE [dbo].[T_NEMKOTOTTMUNKAIDO] WITH CHECK CHECK CONSTRAINT [FK_402667705_402667703];

ALTER TABLE [dbo].[T_KKTANITOMUVTERTIPUS] WITH CHECK CHECK CONSTRAINT [FK_402838805_402838803];

ALTER TABLE [dbo].[T_FELHASZNALO] WITH CHECK CHECK CONSTRAINT [FK_893505_893503];

ALTER TABLE [dbo].[T_ETKEZESIKEDVEZMENYTIPUS] WITH CHECK CHECK CONSTRAINT [FK_402536005_402536003];

ALTER TABLE [dbo].[T_ERETTSEGIVALASZ] WITH CHECK CHECK CONSTRAINT [FK_402823405_402823403];

ALTER TABLE [dbo].[T_NEBULO] WITH CHECK CHECK CONSTRAINT [FK_402736305_402736303];

ALTER TABLE [dbo].[T_MUKODESIHELYADATSZOLGALTATAS] WITH CHECK CHECK CONSTRAINT [FK_402771505_402771503];

ALTER TABLE [dbo].[T_ORALATOGATAS] WITH CHECK CHECK CONSTRAINT [FK_402572805_402572803];

ALTER TABLE [dbo].[T_JOGYAKORLAT] WITH CHECK CHECK CONSTRAINT [FK_402590605_402590603];

ALTER TABLE [dbo].[T_RENDSZERERTESITESEK] WITH CHECK CHECK CONSTRAINT [FK_402613705_402613703];

ALTER TABLE [dbo].[T_DIAKIGAZOLVANYIGENYLES] WITH CHECK CHECK CONSTRAINT [FK_99079105_99079103];

ALTER TABLE [dbo].[T_ORARENDIORATULAJDONSAG] WITH CHECK CHECK CONSTRAINT [FK_402799805_402799803];

ALTER TABLE [dbo].[T_MUNKAKORTIPUS] WITH CHECK CHECK CONSTRAINT [FK_402515705_402515703];

ALTER TABLE [dbo].[T_CREDITCARDREPLY] WITH CHECK CHECK CONSTRAINT [FK_2288705_2288703];

ALTER TABLE [dbo].[T_ESLADAT] WITH CHECK CHECK CONSTRAINT [FK_402666905_402666903];

ALTER TABLE [dbo].[T_KKAMIKLASSZIKUSTIPUS] WITH CHECK CHECK CONSTRAINT [FK_402838705_402838703];

ALTER TABLE [dbo].[T_HATRANYOSHELYZETTIPUS] WITH CHECK CHECK CONSTRAINT [FK_402535905_402535903];

ALTER TABLE [dbo].[T_OTPJELENTESSTATUS] WITH CHECK CHECK CONSTRAINT [FK_249131205_249131203];

ALTER TABLE [dbo].[T_AUTOMATICMESSAGES] WITH CHECK CHECK CONSTRAINT [FK_402365005_402365003];

ALTER TABLE [dbo].[T_TANULOCSOPORT] WITH CHECK CHECK CONSTRAINT [FK_402551805_402551803];

ALTER TABLE [dbo].[T_ERETTSEGIKERDES] WITH CHECK CHECK CONSTRAINT [FK_402821805_402821803];

ALTER TABLE [dbo].[T_INTEZMENYESZKOZADATSZOLGALTA] WITH CHECK CHECK CONSTRAINT [FK_402767505_402767503];

ALTER TABLE [dbo].[T_MAGATARTASERTEKELESTIPUS] WITH CHECK CHECK CONSTRAINT [FK_402572105_402572103];

ALTER TABLE [dbo].[T_EVENTTYPE] WITH CHECK CHECK CONSTRAINT [FK_402590105_402590103];

ALTER TABLE [dbo].[T_MUNKAUGYIADATOK] WITH CHECK CHECK CONSTRAINT [FK_402611605_402611603];

ALTER TABLE [dbo].[T_ORATULAJDONSAGTIPUS] WITH CHECK CHECK CONSTRAINT [FK_402797005_402797003];

ALTER TABLE [dbo].[T_MUKODESIHELY] WITH CHECK CHECK CONSTRAINT [FK_402514805_402514803];

ALTER TABLE [dbo].[T_SYSTEMPARAMETER] WITH CHECK CHECK CONSTRAINT [FK_2107905_2107903];

ALTER TABLE [dbo].[T_TANULOESLADATOK] WITH CHECK CHECK CONSTRAINT [FK_402662605_402662603];

ALTER TABLE [dbo].[T_SCSTICKER] WITH CHECK CHECK CONSTRAINT [FK_99079005_99079003];

ALTER TABLE [dbo].[T_KKGYOGYPEDTERTIPUS] WITH CHECK CHECK CONSTRAINT [FK_402838605_402838603];

ALTER TABLE [dbo].[T_VALLAS] WITH CHECK CHECK CONSTRAINT [FK_402534005_402534003];

ALTER TABLE [dbo].[T_OTPJELENTESEK] WITH CHECK CHECK CONSTRAINT [FK_248900605_248900603];

ALTER TABLE [dbo].[T_CIMTARCSOPORT] WITH CHECK CHECK CONSTRAINT [FK_402546505_402546503];

ALTER TABLE [dbo].[T_PERSONMESSAGE] WITH CHECK CHECK CONSTRAINT [FK_881105_881103];

ALTER TABLE [dbo].[T_LICENCEFUNKCIOKTIPUS] WITH CHECK CHECK CONSTRAINT [FK_402820405_402820403];

ALTER TABLE [dbo].[T_VEZETOIORASZAMOKTIPUS] WITH CHECK CHECK CONSTRAINT [FK_402763405_402763403];

ALTER TABLE [dbo].[T_SZORGALOMERTEKELESTIPUS] WITH CHECK CHECK CONSTRAINT [FK_402571705_402571703];

ALTER TABLE [dbo].[T_TANITASIORATULAJDONSAG] WITH CHECK CHECK CONSTRAINT [FK_402795405_402795403];

ALTER TABLE [dbo].[T_DICTIONARYITEMBASE] WITH CHECK CHECK CONSTRAINT [FK_2103805_2103803];

ALTER TABLE [dbo].[T_ESLADATTIPUS] WITH CHECK CHECK CONSTRAINT [FK_402662505_402662503];

ALTER TABLE [dbo].[T_KKKEPESITESTIPUS] WITH CHECK CHECK CONSTRAINT [FK_402838505_402838503];

ALTER TABLE [dbo].[T_TANEV] WITH CHECK CHECK CONSTRAINT [FK_4026254_4026253];

ALTER TABLE [dbo].[T_OTPJELENTESTIPUS] WITH CHECK CHECK CONSTRAINT [FK_248860605_248860603];

ALTER TABLE [dbo].[T_ALKALMAZOTT] WITH CHECK CHECK CONSTRAINT [FK_402513905_402513903];

ALTER TABLE [dbo].[T_SCINSET] WITH CHECK CHECK CONSTRAINT [FK_99078905_99078903];

ALTER TABLE [dbo].[T_CIMTAR] WITH CHECK CHECK CONSTRAINT [FK_402546205_402546203];

ALTER TABLE [dbo].[T_LICENCE] WITH CHECK CHECK CONSTRAINT [FK_402820005_402820003];

ALTER TABLE [dbo].[T_FOGLALKOZTATASTIPUSA] WITH CHECK CHECK CONSTRAINT [FK_402762905_402762903];

ALTER TABLE [dbo].[T_EMAILADATOK] WITH CHECK CHECK CONSTRAINT [FK_394052705_394052703];

ALTER TABLE [dbo].[T_MESSAGE] WITH CHECK CHECK CONSTRAINT [FK_880005_880003];

ALTER TABLE [dbo].[T_TANULOESEMENY] WITH CHECK CHECK CONSTRAINT [FK_402569905_402569903];

ALTER TABLE [dbo].[T_SCHEDULERTRIGGERS] WITH CHECK CHECK CONSTRAINT [FK_402589305_402589303];

ALTER TABLE [dbo].[T_FELVETELSTATUSZATIPUS] WITH CHECK CHECK CONSTRAINT [FK_402736205_402736203];

ALTER TABLE [dbo].[T_NATKERDOIV] WITH CHECK CHECK CONSTRAINT [FK_402793505_402793503];

ALTER TABLE [dbo].[T_FOGLALKOZASARCHIV] WITH CHECK CHECK CONSTRAINT [FK_402659305_402659303];

ALTER TABLE [dbo].[T_KKSZAKTIPUS] WITH CHECK CHECK CONSTRAINT [FK_402838405_402838403];

ALTER TABLE [dbo].[T_SYSTEMSETTINGSCONTROLTYPE] WITH CHECK CHECK CONSTRAINT [FK_402610905_402610903];

ALTER TABLE [dbo].[T_KOZTERULETJELLEG] WITH CHECK CHECK CONSTRAINT [FK_242511905_242511903];

ALTER TABLE [dbo].[T_CSENGETESIREND] WITH CHECK CHECK CONSTRAINT [FK_402545605_402545603];

ALTER TABLE [dbo].[T_ERTMONDATBANKTIPUS] WITH CHECK CHECK CONSTRAINT [FK_402846405_402846403];

ALTER TABLE [dbo].[T_TELEFON] WITH CHECK CHECK CONSTRAINT [FK_2077505_2077503];

ALTER TABLE [dbo].[T_OSZTALYCSOPORT] WITH CHECK CHECK CONSTRAINT [FK_402529605_402529603];

ALTER TABLE [dbo].[T_SCTEMPORARYCARD] WITH CHECK CHECK CONSTRAINT [FK_99078805_99078803];

ALTER TABLE [dbo].[T_ERETTSEGISZINT] WITH CHECK CHECK CONSTRAINT [FK_402761905_402761903];

ALTER TABLE [dbo].[T_DIGESTEMAILMESSAGE] WITH CHECK CHECK CONSTRAINT [FK_394046705_394046703];

ALTER TABLE [dbo].[T_PENZNEMTIPUS] WITH CHECK CHECK CONSTRAINT [FK_402818705_402818703];

ALTER TABLE [dbo].[T_ESEMENYTIPUS] WITH CHECK CHECK CONSTRAINT [FK_402569805_402569803];

ALTER TABLE [dbo].[T_SCHEDULERCONTEXTS] WITH CHECK CHECK CONSTRAINT [FK_402588805_402588803];

ALTER TABLE [dbo].[T_UPLOADEDFILE] WITH CHECK CHECK CONSTRAINT [FK_402729805_402729803];

ALTER TABLE [dbo].[T_SOROLASOKATIPUS] WITH CHECK CHECK CONSTRAINT [FK_402653905_402653903];

ALTER TABLE [dbo].[T_KKAMIZENEMUVKATTIPUS] WITH CHECK CHECK CONSTRAINT [FK_402838305_402838303];

ALTER TABLE [dbo].[T_ERTEKELESMONDATBANK] WITH CHECK CHECK CONSTRAINT [FK_402791505_402791503];

ALTER TABLE [dbo].[T_SCHEDULERLOG] WITH CHECK CHECK CONSTRAINT [FK_402608805_402608803];

ALTER TABLE [dbo].[T_APPOINTMENT] WITH CHECK CHECK CONSTRAINT [FK_218658805_218658803];

ALTER TABLE [dbo].[T_PAYMENTTITLE] WITH CHECK CHECK CONSTRAINT [FK_821405_821403];

ALTER TABLE [dbo].[T_KKTANTARGYKATEGORIA] WITH CHECK CHECK CONSTRAINT [FK_402842805_402842803];

ALTER TABLE [dbo].[T_HETNAPJATIPUS] WITH CHECK CHECK CONSTRAINT [FK_402544905_402544903];

ALTER TABLE [dbo].[T_ERETTSEGITIPUS] WITH CHECK CHECK CONSTRAINT [FK_402761805_402761803];

ALTER TABLE [dbo].[T_EMAILHIBALOG] WITH CHECK CHECK CONSTRAINT [FK_394046505_394046503];

ALTER TABLE [dbo].[T_ANYANYELV] WITH CHECK CHECK CONSTRAINT [FK_402513805_402513803];

ALTER TABLE [dbo].[T_MEROALLAS] WITH CHECK CHECK CONSTRAINT [FK_402818405_402818403];

ALTER TABLE [dbo].[T_SCCARD] WITH CHECK CHECK CONSTRAINT [FK_99078705_99078703];

ALTER TABLE [dbo].[T_SCHEDULERJOBS] WITH CHECK CHECK CONSTRAINT [FK_402588505_402588503];

ALTER TABLE [dbo].[T_FORMTYPE] WITH CHECK CHECK CONSTRAINT [FK_1546805_1546803];

ALTER TABLE [dbo].[T_IDOKERET] WITH CHECK CHECK CONSTRAINT [FK_402719205_402719203];

ALTER TABLE [dbo].[T_CSOPORTTIPUS_FOGLALKOZASTIPU] WITH CHECK CHECK CONSTRAINT [FK_402653705_402653703];

ALTER TABLE [dbo].[T_KOZOSSEGISZOLGALATTIPUS] WITH CHECK CHECK CONSTRAINT [FK_402791105_402791103];

ALTER TABLE [dbo].[T_MULASZTASSTATISZTIKATIPUS] WITH CHECK CHECK CONSTRAINT [FK_402607805_402607803];

ALTER TABLE [dbo].[T_BANK] WITH CHECK CHECK CONSTRAINT [FK_212192505_212192503];

ALTER TABLE [dbo].[T_IGAZOLASTIPUS] WITH CHECK CHECK CONSTRAINT [FK_402569605_402569603];

ALTER TABLE [dbo].[T_KKKEPESITESJELLTIPUS] WITH CHECK CHECK CONSTRAINT [FK_402842705_402842703];

ALTER TABLE [dbo].[T_TANEVRENDJE] WITH CHECK CHECK CONSTRAINT [FK_402544105_402544103];

ALTER TABLE [dbo].[T_ERETTSEGIEREDMENY] WITH CHECK CHECK CONSTRAINT [FK_402760905_402760903];

ALTER TABLE [dbo].[T_DIGESTMESSAGEQUEUE] WITH CHECK CHECK CONSTRAINT [FK_391192005_391192003];

ALTER TABLE [dbo].[T_IGAZOLVANYTIPUS] WITH CHECK CHECK CONSTRAINT [FK_402513405_402513403];

ALTER TABLE [dbo].[T_MEROHELYTIPUS] WITH CHECK CHECK CONSTRAINT [FK_402818305_402818303];

ALTER TABLE [dbo].[T_ERRORSTATUS] WITH CHECK CHECK CONSTRAINT [FK_53988005_53988003];

ALTER TABLE [dbo].[T_ERTESITES] WITH CHECK CHECK CONSTRAINT [FK_402586805_402586803];

ALTER TABLE [dbo].[T_EPENZTARCABIZONYLAT] WITH CHECK CHECK CONSTRAINT [FK_402718905_402718903];

ALTER TABLE [dbo].[T_KIRTELEPHELY] WITH CHECK CHECK CONSTRAINT [FK_402653005_402653003];

ALTER TABLE [dbo].[T_OGTEREMFOGLALTSAG] WITH CHECK CHECK CONSTRAINT [FK_402784705_402784703];

ALTER TABLE [dbo].[T_TANULOTARGYMULASZTASSTATISZT] WITH CHECK CHECK CONSTRAINT [FK_402606805_402606803];

ALTER TABLE [dbo].[T_CSENGETESIRENDORA] WITH CHECK CHECK CONSTRAINT [FK_402567905_402567903];

ALTER TABLE [dbo].[T_USERPROFILE] WITH CHECK CHECK CONSTRAINT [FK_203009405_203009403];

ALTER TABLE [dbo].[T_KKJAZZZENE] WITH CHECK CHECK CONSTRAINT [FK_402842505_402842503];

ALTER TABLE [dbo].[T_FORMS] WITH CHECK CHECK CONSTRAINT [FK_1540405_1540403];

ALTER TABLE [dbo].[T_ERETTSEGITANTARGYADATOK] WITH CHECK CHECK CONSTRAINT [FK_402759905_402759903];

ALTER TABLE [dbo].[T_SCCARDBEVONASOKA] WITH CHECK CHECK CONSTRAINT [FK_383219005_383219003];

ALTER TABLE [dbo].[T_MUNKAVISZONYTIPUS] WITH CHECK CHECK CONSTRAINT [FK_402513305_402513303];

ALTER TABLE [dbo].[T_KOZMUSZAMLA] WITH CHECK CHECK CONSTRAINT [FK_402817105_402817103];

ALTER TABLE [dbo].[T_FEETYPE] WITH CHECK CHECK CONSTRAINT [FK_28379705_28379703];

ALTER TABLE [dbo].[T_OSSZEGTULLEPESTIPUS] WITH CHECK CHECK CONSTRAINT [FK_402718805_402718803];

ALTER TABLE [dbo].[T_TRANSACTIONANALYSISFILELINE] WITH CHECK CHECK CONSTRAINT [FK_813305_813303];

ALTER TABLE [dbo].[T_MUNKAIDOKEDVEZMENYOKA] WITH CHECK CHECK CONSTRAINT [FK_402636605_402636603];

ALTER TABLE [dbo].[T_KIRKONTENERELEMSTATUSZ] WITH CHECK CHECK CONSTRAINT [FK_402834805_402834803];

ALTER TABLE [dbo].[T_HETIRENDTIPUS] WITH CHECK CHECK CONSTRAINT [FK_402544005_402544003];

ALTER TABLE [dbo].[T_GONDVISELOERTESITES] WITH CHECK CHECK CONSTRAINT [FK_402586605_402586603];

ALTER TABLE [dbo].[T_TANULOMULASZTASSTATISZTIKA] WITH CHECK CHECK CONSTRAINT [FK_402605305_402605303];

ALTER TABLE [dbo].[T_TANTERVIJELLEG] WITH CHECK CHECK CONSTRAINT [FK_402529305_402529303];

ALTER TABLE [dbo].[T_MULASZTASTIPUS] WITH CHECK CHECK CONSTRAINT [FK_402565905_402565903];

ALTER TABLE [dbo].[T_OGFOGLALKOZASFOGLALTSAG] WITH CHECK CHECK CONSTRAINT [FK_402784205_402784203];

ALTER TABLE [dbo].[T_DIAKIGAZOLVANYIGENYSTATUSZ] WITH CHECK CHECK CONSTRAINT [FK_202649705_202649703];

ALTER TABLE [dbo].[T_KKKLASSZIKUSZENE] WITH CHECK CHECK CONSTRAINT [FK_402842305_402842303];

ALTER TABLE [dbo].[T_ERETTSEGITANTARGY] WITH CHECK CHECK CONSTRAINT [FK_402759805_402759803];

ALTER TABLE [dbo].[T_MEGYE] WITH CHECK CHECK CONSTRAINT [FK_371584605_371584603];

ALTER TABLE [dbo].[T_TEREM] WITH CHECK CHECK CONSTRAINT [FK_402512205_402512203];

ALTER TABLE [dbo].[T_PAYMENTTITLETYPE] WITH CHECK CHECK CONSTRAINT [FK_22824705_22824703];

ALTER TABLE [dbo].[T_IMPOSITIONSHAREDRULES] WITH CHECK CHECK CONSTRAINT [FK_1429805_1429803];

ALTER TABLE [dbo].[T_EPENZTARCATETEL] WITH CHECK CHECK CONSTRAINT [FK_402718105_402718103];

ALTER TABLE [dbo].[T_TRANSACTIONANALYSISFILE] WITH CHECK CHECK CONSTRAINT [FK_813005_813003];

ALTER TABLE [dbo].[T_BESOROLASIFOKOZATTIPUS] WITH CHECK CHECK CONSTRAINT [FK_402635305_402635303];

ALTER TABLE [dbo].[T_KIRKONTENER] WITH CHECK CHECK CONSTRAINT [FK_402832105_402832103];

ALTER TABLE [dbo].[T_NAPTIPUS] WITH CHECK CHECK CONSTRAINT [FK_402543905_402543903];

ALTER TABLE [dbo].[T_ERTESITESTIPUS] WITH CHECK CHECK CONSTRAINT [FK_402586505_402586503];

ALTER TABLE [dbo].[T_OLDALLATOGATOTTSAG] WITH CHECK CHECK CONSTRAINT [FK_402604205_402604203];

ALTER TABLE [dbo].[T_MEROHELY] WITH CHECK CHECK CONSTRAINT [FK_402816705_402816703];

ALTER TABLE [dbo].[T_TESTNEVELESTIPUS] WITH CHECK CHECK CONSTRAINT [FK_402527905_402527903];

ALTER TABLE [dbo].[T_TANULOMULASZTAS] WITH CHECK CHECK CONSTRAINT [FK_402565405_402565403];

ALTER TABLE [dbo].[T_SCSTICKERSTATUS] WITH CHECK CHECK CONSTRAINT [FK_202649405_202649403];

ALTER TABLE [dbo].[T_KKAMIVEGZETTSEG] WITH CHECK CHECK CONSTRAINT [FK_402842105_402842103];

ALTER TABLE [dbo].[T_OGEXPORTORAREND] WITH CHECK CHECK CONSTRAINT [FK_402783805_402783803];

ALTER TABLE [dbo].[T_TOVABBIMUNKAUGYIADATOK] WITH CHECK CHECK CONSTRAINT [FK_402755805_402755803];

ALTER TABLE [dbo].[T_SYSTEMPARAMETERVALUE] WITH CHECK CHECK CONSTRAINT [FK_355895805_355895803];

ALTER TABLE [dbo].[T_EMAILTIPUS] WITH CHECK CHECK CONSTRAINT [FK_4247205_4247203];

ALTER TABLE [dbo].[T_IMPOSITION] WITH CHECK CHECK CONSTRAINT [FK_810805_810803];

ALTER TABLE [dbo].[T_INTEZMENYADATSZOLGALTATAS] WITH CHECK CHECK CONSTRAINT [FK_4026362_4026361];

ALTER TABLE [dbo].[T_KIRKONTENERSTATUSZ] WITH CHECK CHECK CONSTRAINT [FK_402831605_402831603];

ALTER TABLE [dbo].[T_EPENZTARCATETELSTATUSZ] WITH CHECK CHECK CONSTRAINT [FK_402718005_402718003];

ALTER TABLE [dbo].[T_FELHASZNALOERTESITES] WITH CHECK CHECK CONSTRAINT [FK_402586305_402586303];

ALTER TABLE [dbo].[T_ESZKOZTIPUS] WITH CHECK CHECK CONSTRAINT [FK_402512105_402512103];

ALTER TABLE [dbo].[T_FELADATELLATASIHELY] WITH CHECK CHECK CONSTRAINT [FK_402601005_402601003];

ALTER TABLE [dbo].[T_IMPOSITIONGROUP] WITH CHECK CHECK CONSTRAINT [FK_1404405_1404403];

ALTER TABLE [dbo].[T_ESZKOZJELLEG] WITH CHECK CHECK CONSTRAINT [FK_402527805_402527803];

ALTER TABLE [dbo].[T_ERTEKELESMOD] WITH CHECK CHECK CONSTRAINT [FK_402565305_402565303];

ALTER TABLE [dbo].[T_KOZMUSZAMLATIPUS] WITH CHECK CHECK CONSTRAINT [FK_402816605_402816603];

ALTER TABLE [dbo].[T_FOGLALKOZASTIPUS] WITH CHECK CHECK CONSTRAINT [FK_402542505_402542503];

ALTER TABLE [dbo].[T_MUNKAVISZONYJELLEGE] WITH CHECK CHECK CONSTRAINT [FK_193161505_193161503];

ALTER TABLE [dbo].[T_KKGYOGYPEDVEGZETTSEG] WITH CHECK CHECK CONSTRAINT [FK_402841905_402841903];

ALTER TABLE [dbo].[T_OGORARENDIORA] WITH CHECK CHECK CONSTRAINT [FK_402783305_402783303];

ALTER TABLE [dbo].[T_EMAILUZENET] WITH CHECK CHECK CONSTRAINT [FK_331018805_331018803];

ALTER TABLE [dbo].[T_TELEFONTIPUS] WITH CHECK CHECK CONSTRAINT [FK_4165705_4165703];

ALTER TABLE [dbo].[T_RESZSZAKKEPESITESTIPUS] WITH CHECK CHECK CONSTRAINT [FK_402755005_402755003];

ALTER TABLE [dbo].[T_KIRKONTENERELEM] WITH CHECK CHECK CONSTRAINT [FK_402831405_402831403];

ALTER TABLE [dbo].[T_EPENZTARCAPARAMETEREK] WITH CHECK CHECK CONSTRAINT [FK_402717105_402717103];

ALTER TABLE [dbo].[T_ERTESITESSZINTIPUS] WITH CHECK CHECK CONSTRAINT [FK_402586205_402586203];

ALTER TABLE [dbo].[T_ESZKOZKATEGORIA] WITH CHECK CHECK CONSTRAINT [FK_402512005_402512003];

ALTER TABLE [dbo].[T_KIZAROCSOPORT] WITH CHECK CHECK CONSTRAINT [FK_402600505_402600503];

ALTER TABLE [dbo].[T_CSOPORT] WITH CHECK CHECK CONSTRAINT [FK_402527705_402527703];

ALTER TABLE [dbo].[T_PEDAGOGUSSTATUSZ] WITH CHECK CHECK CONSTRAINT [FK_402634205_402634203];

ALTER TABLE [dbo].[T_OSZTALYZATTIPUS] WITH CHECK CHECK CONSTRAINT [FK_402565205_402565203];

ALTER TABLE [dbo].[T_FOGLALKOZAS] WITH CHECK CHECK CONSTRAINT [FK_402542205_402542203];

ALTER TABLE [dbo].[T_KULFOLDISTATUSZTIPUS] WITH CHECK CHECK CONSTRAINT [FK_176808005_176808003];

ALTER TABLE [dbo].[T_KKNEPZENE] WITH CHECK CHECK CONSTRAINT [FK_402841605_402841603];

ALTER TABLE [dbo].[T_OGINTEZMENYFOGLALTSAG] WITH CHECK CHECK CONSTRAINT [FK_402776105_402776103];

ALTER TABLE [dbo].[T_FINANCIALCODE] WITH CHECK CHECK CONSTRAINT [FK_1331005_1331003];

ALTER TABLE [dbo].[T_PAYINGTYPE] WITH CHECK CHECK CONSTRAINT [FK_3874305_3874303];

ALTER TABLE [dbo].[T_FELHASZNALOBELEPESTORTENET] WITH CHECK CHECK CONSTRAINT [FK_319582805_319582803];

ALTER TABLE [dbo].[T_AGAZATTIPUS] WITH CHECK CHECK CONSTRAINT [FK_402754905_402754903];

ALTER TABLE [dbo].[T_KIRSZOLGALTATASTIPUS] WITH CHECK CHECK CONSTRAINT [FK_402831205_402831203];

ALTER TABLE [dbo].[T_TEVEKENYSEG] WITH CHECK CHECK CONSTRAINT [FK_402583905_402583903];

ALTER TABLE [dbo].[T_ESZKOZ] WITH CHECK CHECK CONSTRAINT [FK_402509805_402509803];

ALTER TABLE [dbo].[T_RENDSZERBEALLITASTIPUS] WITH CHECK CHECK CONSTRAINT [FK_402600405_402600403];

ALTER TABLE [dbo].[T_ESZKOZCEL] WITH CHECK CHECK CONSTRAINT [FK_402527605_402527603];

ALTER TABLE [dbo].[T_KRETATIPUS] WITH CHECK CHECK CONSTRAINT [FK_402633905_402633903];

ALTER TABLE [dbo].[T_ERTEKELESTIPUS] WITH CHECK CHECK CONSTRAINT [FK_402565105_402565103];

ALTER TABLE [dbo].[T_JELSZOVISSZAALLITAS] WITH CHECK CHECK CONSTRAINT [FK_402814805_402814803];

ALTER TABLE [dbo].[T_VPOSCONFIG] WITH CHECK CHECK CONSTRAINT [FK_163886705_163886703];

ALTER TABLE [dbo].[T_KKELEKTROAKUZENE] WITH CHECK CHECK CONSTRAINT [FK_402841405_402841403];

ALTER TABLE [dbo].[T_ALLAMPOLGARSAG] WITH CHECK CHECK CONSTRAINT [FK_3872705_3872703];

ALTER TABLE [dbo].[T_HIBAJEGY] WITH CHECK CHECK CONSTRAINT [FK_402695805_402695803];

ALTER TABLE [dbo].[T_OGGENERATORALAP] WITH CHECK CHECK CONSTRAINT [FK_402775105_402775103];

ALTER TABLE [dbo].[T_FEE] WITH CHECK CHECK CONSTRAINT [FK_1324505_1324503];

ALTER TABLE [dbo].[T_SZAKMACSOPORTTIPUS] WITH CHECK CHECK CONSTRAINT [FK_402754805_402754803];

ALTER TABLE [dbo].[T_HONAPOK] WITH CHECK CHECK CONSTRAINT [FK_304453105_304453103];

ALTER TABLE [dbo].[T_SZAKTIPUS] WITH CHECK CHECK CONSTRAINT [FK_402830805_402830803];

ALTER TABLE [dbo].[T_TARGYKATEGORIATIPUS] WITH CHECK CHECK CONSTRAINT [FK_402540605_402540603];

ALTER TABLE [dbo].[T_TEVEKENYSEGTIPUS] WITH CHECK CHECK CONSTRAINT [FK_402583805_402583803];

ALTER TABLE [dbo].[T_ORATERVTARGY] WITH CHECK CHECK CONSTRAINT [FK_402600205_402600203];

ALTER TABLE [dbo].[T_MERTEKEGYSEGTIPUS] WITH CHECK CHECK CONSTRAINT [FK_402524605_402524603];

ALTER TABLE [dbo].[T_TANULOERTEKELES] WITH CHECK CHECK CONSTRAINT [FK_402564105_402564103];

ALTER TABLE [dbo].[T_HITTANADATSZOLGALTATAS] WITH CHECK CHECK CONSTRAINT [FK_402813505_402813503];

ALTER TABLE [dbo].[T_SMS] WITH CHECK CHECK CONSTRAINT [FK_136198505_136198503];

ALTER TABLE [dbo].[T_KKTERULET] WITH CHECK CHECK CONSTRAINT [FK_402841205_402841203];

ALTER TABLE [dbo].[T_INGYENESTANKONYVELLATAS] WITH CHECK CHECK CONSTRAINT [FK_402509605_402509603];

ALTER TABLE [dbo].[T_STUDENTCARDSTATUS] WITH CHECK CHECK CONSTRAINT [FK_3867705_3867703];

ALTER TABLE [dbo].[T_SZAKKEPESITESTIPUS] WITH CHECK CHECK CONSTRAINT [FK_402753905_402753903];

ALTER TABLE [dbo].[T_PAYMENTTITLE_ROLES] WITH CHECK CHECK CONSTRAINT [FK_289347005_289347003];

ALTER TABLE [dbo].[T_OGOSZTALYCSOPORTFOGLALTSAG] WITH CHECK CHECK CONSTRAINT [FK_402774605_402774603];

ALTER TABLE [dbo].[T_GIMNAZIUMIEVFOLYAMTIPUS] WITH CHECK CHECK CONSTRAINT [FK_402830505_402830503];

ALTER TABLE [dbo].[T_EVFOLYAMTIPUS] WITH CHECK CHECK CONSTRAINT [FK_402540505_402540503];

ALTER TABLE [dbo].[T_FALIUJSAGBEJEGYZES] WITH CHECK CHECK CONSTRAINT [FK_402581505_402581503];

ALTER TABLE [dbo].[T_RENDSZERBEALLITAS] WITH CHECK CHECK CONSTRAINT [FK_402599705_402599703];

ALTER TABLE [dbo].[T_SZEREPKOR] WITH CHECK CHECK CONSTRAINT [FK_1309205_1309203];

ALTER TABLE [dbo].[T_INTEZMENYADATOK] WITH CHECK CHECK CONSTRAINT [FK_4026244_4026243];

ALTER TABLE [dbo].[T_NAPTARIHET] WITH CHECK CHECK CONSTRAINT [FK_402629405_402629403];

ALTER TABLE [dbo].[T_TANITASIORA] WITH CHECK CHECK CONSTRAINT [FK_402557505_402557503];

ALTER TABLE [dbo].[T_HIBAJEGYSTATUSZ] WITH CHECK CHECK CONSTRAINT [FK_402695305_402695303];

ALTER TABLE [dbo].[T_KKTANARVEGZETTSEG] WITH CHECK CHECK CONSTRAINT [FK_402840905_402840903];

ALTER TABLE [dbo].[T_TEREMTIPUS] WITH CHECK CHECK CONSTRAINT [FK_402509305_402509303];

ALTER TABLE [dbo].[T_HITTANTIPUS] WITH CHECK CHECK CONSTRAINT [FK_402813305_402813303];

ALTER TABLE [dbo].[T_SMSMESSAGESTATUS] WITH CHECK CHECK CONSTRAINT [FK_136178505_136178503];

ALTER TABLE [dbo].[T_NATIONALITY] WITH CHECK CHECK CONSTRAINT [FK_3863705_3863703];

ALTER TABLE [dbo].[T_MUKODESIHELYTIPUS] WITH CHECK CHECK CONSTRAINT [FK_402750405_402750403];

ALTER TABLE [dbo].[T_KEPESITES] WITH CHECK CHECK CONSTRAINT [FK_402829405_402829403];

ALTER TABLE [dbo].[T_FALIUJSAGLATOGATTOTSAG] WITH CHECK CHECK CONSTRAINT [FK_402581305_402581303];

ALTER TABLE [dbo].[T_OGFOGLALTSAGTIPUS] WITH CHECK CHECK CONSTRAINT [FK_402774505_402774503];

ALTER TABLE [dbo].[T_ORATERV] WITH CHECK CHECK CONSTRAINT [FK_402599405_402599403];

ALTER TABLE [dbo].[T_STUDENTCARDTYPE] WITH CHECK CHECK CONSTRAINT [FK_1167105_1167103];

ALTER TABLE [dbo].[T_FENNTARTOTIPUS] WITH CHECK CHECK CONSTRAINT [FK_402519805_402519803];

ALTER TABLE [dbo].[T_HELYETTESITESIIDOSZAK] WITH CHECK CHECK CONSTRAINT [FK_402628605_402628603];

ALTER TABLE [dbo].[T_PRIORITAS] WITH CHECK CHECK CONSTRAINT [FK_402695205_402695203];

ALTER TABLE [dbo].[T_KKTANITOVEZGETTSEG] WITH CHECK CHECK CONSTRAINT [FK_402840705_402840703];

ALTER TABLE [dbo].[T_MAGANTANULOSAGOKA] WITH CHECK CHECK CONSTRAINT [FK_402509205_402509203];

ALTER TABLE [dbo].[T_HAZIFELADATOK] WITH CHECK CHECK CONSTRAINT [FK_402811205_402811203];

ALTER TABLE [dbo].[T_TANTARGY] WITH CHECK CHECK CONSTRAINT [FK_402539905_402539903];

ALTER TABLE [dbo].[T_TRANSACTIONANALYSISFILESTATU] WITH CHECK CHECK CONSTRAINT [FK_131202405_131202403];

ALTER TABLE [dbo].[T_DIAKIGAZOLVANYIGENYHIBASTATU] WITH CHECK CHECK CONSTRAINT [FK_284754505_284754503];

ALTER TABLE [dbo].[T_MARITALSTATUS] WITH CHECK CHECK CONSTRAINT [FK_3841605_3841603];

ALTER TABLE [dbo].[T_IKTESZKOZHASZNALATMOD] WITH CHECK CHECK CONSTRAINT [FK_402742905_402742903];

ALTER TABLE [dbo].[T_VEGZETTSEG] WITH CHECK CHECK CONSTRAINT [FK_402828705_402828703];

ALTER TABLE [dbo].[T_PEDAGOGUSELETPALYAMODELL] WITH CHECK CHECK CONSTRAINT [FK_402580105_402580103];

ALTER TABLE [dbo].[T_OGFOGLALKOZAS] WITH CHECK CHECK CONSTRAINT [FK_402774105_402774103];

ALTER TABLE [dbo].[T_KIZAROCSOPORTTIPUS] WITH CHECK CHECK CONSTRAINT [FK_402599105_402599103];

ALTER TABLE [dbo].[T_CIM] WITH CHECK CHECK CONSTRAINT [FK_1109405_1109403];

ALTER TABLE [dbo].[T_CSOPORTTIPUS] WITH CHECK CHECK CONSTRAINT [FK_402519105_402519103];

ALTER TABLE [dbo].[T_FORRAS] WITH CHECK CHECK CONSTRAINT [FK_402695105_402695103];

ALTER TABLE [dbo].[T_KKVEGZETTSEGTIPUS] WITH CHECK CHECK CONSTRAINT [FK_402839405_402839403];

ALTER TABLE [dbo].[T_VEGZETTSEGTIPUS] WITH CHECK CHECK CONSTRAINT [FK_402810805_402810803];

ALTER TABLE [dbo].[T_ORSZAGTIPUS] WITH CHECK CHECK CONSTRAINT [FK_129125805_129125803];

ALTER TABLE [dbo].[T_DIAKIGAZOLVANYIGENYTIPUS] WITH CHECK CHECK CONSTRAINT [FK_284654605_284654603];

ALTER TABLE [dbo].[T_IMPOSITIONSTATUS] WITH CHECK CHECK CONSTRAINT [FK_3840805_3840803];

ALTER TABLE [dbo].[T_HELYETTESITESTIPUS] WITH CHECK CHECK CONSTRAINT [FK_402557405_402557403];

ALTER TABLE [dbo].[T_ELSODLEGESIKTESZKOZ] WITH CHECK CHECK CONSTRAINT [FK_402742805_402742803];

ALTER TABLE [dbo].[T_TANULOHAZIFELADAT] WITH CHECK CHECK CONSTRAINT [FK_402827105_402827103];

ALTER TABLE [dbo].[T_ELETPALYAMODELLFOKOZATTIPUS] WITH CHECK CHECK CONSTRAINT [FK_402580005_402580003];

ALTER TABLE [dbo].[T_OGTANTARGYFOGLALTSAG] WITH CHECK CHECK CONSTRAINT [FK_402773605_402773603];

ALTER TABLE [dbo].[T_FELHASZNALOERTESITESBEALLITA] WITH CHECK CHECK CONSTRAINT [FK_402596205_402596203];

ALTER TABLE [dbo].[T_TRANSACTION] WITH CHECK CHECK CONSTRAINT [FK_1073505_1073503];

ALTER TABLE [dbo].[T_ROKONSAGIFOK] WITH CHECK CHECK CONSTRAINT [FK_402517905_402517903];

ALTER TABLE [dbo].[T_TANTERV] WITH CHECK CHECK CONSTRAINT [FK_402539205_402539203];

ALTER TABLE [dbo].[T_SZERZODOSZEMELYPOZICIO] WITH CHECK CHECK CONSTRAINT [FK_402670905_402670903];

ALTER TABLE [dbo].[T_KKAMINEPZENETIPUS] WITH CHECK CHECK CONSTRAINT [FK_402839305_402839303];

ALTER TABLE [dbo].[T_ENTITYATTRIBUTEHISTORY] WITH CHECK CHECK CONSTRAINT [FK_402508005_402508003];

ALTER TABLE [dbo].[T_ELEARNING] WITH CHECK CHECK CONSTRAINT [FK_402809805_402809803];

ALTER TABLE [dbo].[T_USERNOTIFICATION] WITH CHECK CHECK CONSTRAINT [FK_125783105_125783103];

ALTER TABLE [dbo].[T_IMPOSITIONIMPOSITIONGROUP] WITH CHECK CHECK CONSTRAINT [FK_276170205_276170203];

ALTER TABLE [dbo].[T_LANGUAGE] WITH CHECK CHECK CONSTRAINT [FK_3839205_3839203];

ALTER TABLE [dbo].[T_NAPTARINAP] WITH CHECK CHECK CONSTRAINT [FK_402556205_402556203];

ALTER TABLE [dbo].[T_PEDAGOGUSIKTADATSZOLGALTATAS] WITH CHECK CHECK CONSTRAINT [FK_402742405_402742403];

ALTER TABLE [dbo].[T_ELETPALYAMODELLSTATUSZOK] WITH CHECK CHECK CONSTRAINT [FK_402579905_402579903];

ALTER TABLE [dbo].[T_TANARIATLAGSULY] WITH CHECK CHECK CONSTRAINT [FK_402595705_402595703];

ALTER TABLE [dbo].[T_IKTATOTTDOKUMENTUMOK] WITH CHECK CHECK CONSTRAINT [FK_402621205_402621203];

ALTER TABLE [dbo].[T_UZENETCIMZETT] WITH CHECK CHECK CONSTRAINT [FK_402825705_402825703];

ALTER TABLE [dbo].[T_OGFOGLALKOZAS_TEREM] WITH CHECK CHECK CONSTRAINT [FK_402773405_402773403];

ALTER TABLE [dbo].[T_TANULO] WITH CHECK CHECK CONSTRAINT [FK_4026237_4026236];

ALTER TABLE [dbo].[T_TANULO] WITH CHECK CHECK CONSTRAINT [FK_402517805_402517803];

ALTER TABLE [dbo].[T_ENAPLOTIPUS] WITH CHECK CHECK CONSTRAINT [FK_402670805_402670803];

ALTER TABLE [dbo].[T_KKAMIELEKTROAKUTIPUS] WITH CHECK CHECK CONSTRAINT [FK_402839205_402839203];

ALTER TABLE [dbo].[T_ENTITYHISTORY] WITH CHECK CHECK CONSTRAINT [FK_402504305_402504303];

ALTER TABLE [dbo].[T_OKTATASINEVELESIFELADAT] WITH CHECK CHECK CONSTRAINT [FK_402537605_402537603];

ALTER TABLE [dbo].[T_SYSTEMPARAMETERTYPE] WITH CHECK CHECK CONSTRAINT [FK_274081905_274081903];

ALTER TABLE [dbo].[T_PARTNER] WITH CHECK CHECK CONSTRAINT [FK_1068505_1068503];

ALTER TABLE [dbo].[T_CIMTIPUS] WITH CHECK CHECK CONSTRAINT [FK_3836905_3836903];

ALTER TABLE [dbo].[T_WIFIELERES] WITH CHECK CHECK CONSTRAINT [FK_402742305_402742303];

ALTER TABLE [dbo].[T_DICTIONARYTYPE] WITH CHECK CHECK CONSTRAINT [FK_402808305_402808303];

ALTER TABLE [dbo].[T_TANMENET] WITH CHECK CHECK CONSTRAINT [FK_402555605_402555603];

ALTER TABLE [dbo].[T_ESEMENYZARADEKTIPUS] WITH CHECK CHECK CONSTRAINT [FK_402579705_402579703];

ALTER TABLE [dbo].[T_TANARITANTARGY] WITH CHECK CHECK CONSTRAINT [FK_402594005_402594003];

ALTER TABLE [dbo].[T_JOGOSULTSAG] WITH CHECK CHECK CONSTRAINT [FK_402619105_402619103];

ALTER TABLE [dbo].[T_ESEMENYSTATUSZ] WITH CHECK CHECK CONSTRAINT [FK_125763105_125763103];

ALTER TABLE [dbo].[T_ENAPLOFORRAS] WITH CHECK CHECK CONSTRAINT [FK_402670705_402670703];

ALTER TABLE [dbo].[T_KKAMIVEGZETTSEGTIPUS] WITH CHECK CHECK CONSTRAINT [FK_402839105_402839103];

ALTER TABLE [dbo].[T_OGOSZTALYCSOPORT] WITH CHECK CHECK CONSTRAINT [FK_402773005_402773003];

ALTER TABLE [dbo].[T_FELHASZNALOBELEPES] WITH CHECK CHECK CONSTRAINT [FK_402502205_402502203];

ALTER TABLE [dbo].[T_UZENETJOGKORTIPUS] WITH CHECK CHECK CONSTRAINT [FK_402825605_402825603];

ALTER TABLE [dbo].[T_ERTELMIFOGYATEKOSTIPUS] WITH CHECK CHECK CONSTRAINT [FK_402537205_402537203];

ALTER TABLE [dbo].[T_ONLINEUSER] WITH CHECK CHECK CONSTRAINT [FK_265686405_265686403];

ALTER TABLE [dbo].[T_NEM] WITH CHECK CHECK CONSTRAINT [FK_3833005_3833003];

ALTER TABLE [dbo].[T_IKTKOMPETENCIASZINT] WITH CHECK CHECK CONSTRAINT [FK_402742205_402742203];

ALTER TABLE [dbo].[T_ORARENDIORA] WITH CHECK CHECK CONSTRAINT [FK_402553005_402553003];

ALTER TABLE [dbo].[T_TANULOMENTESSEG] WITH CHECK CHECK CONSTRAINT [FK_402576905_402576903];

ALTER TABLE [dbo].[T_ERTESITESGENERALASTORTENET] WITH CHECK CHECK CONSTRAINT [FK_402592805_402592803];

ALTER TABLE [dbo].[T_ERRORTYPE] WITH CHECK CHECK CONSTRAINT [FK_1047705_1047703];

ALTER TABLE [dbo].[T_SZEREPKORTIPUS] WITH CHECK CHECK CONSTRAINT [FK_402618905_402618903];

ALTER TABLE [dbo].[T_TRANSACTIONSTATUS] WITH CHECK CHECK CONSTRAINT [FK_102945805_102945803];

ALTER TABLE [dbo].[T_TANULOERTEKELESLATTAMOZAS] WITH CHECK CHECK CONSTRAINT [FK_402805005_402805003];

ALTER TABLE [dbo].[T_ADATSZOLGALTATASENAPLO] WITH CHECK CHECK CONSTRAINT [FK_402669405_402669403];

ALTER TABLE [dbo].[T_KKAMITERULETTIPUS] WITH CHECK CHECK CONSTRAINT [FK_402839005_402839003];

ALTER TABLE [dbo].[T_UZENET] WITH CHECK CHECK CONSTRAINT [FK_402824805_402824803];

ALTER TABLE [dbo].[T_HALLASSERULTTIPUS] WITH CHECK CHECK CONSTRAINT [FK_402537105_402537103];

ALTER TABLE [dbo].[T_LOGINLINKS] WITH CHECK CHECK CONSTRAINT [FK_261224905_261224903];

ALTER TABLE [dbo].[T_BANKACCOUNT] WITH CHECK CHECK CONSTRAINT [FK_2552905_2552903];

ALTER TABLE [dbo].[T_OGTEREM_TANTARGY] WITH CHECK CHECK CONSTRAINT [FK_402772905_402772903];

ALTER TABLE [dbo].[T_TANULOERTEKELES] WITH CHECK CHECK CONSTRAINT [FK_402564102_402564100];

ALTER TABLE [dbo].[T_TANULOERTEKELES] WITH CHECK CHECK CONSTRAINT [FK_4025641_4025644];

ALTER TABLE [dbo].[T_TANULOERTEKELES] WITH CHECK CHECK CONSTRAINT [FK_4025641_4026317];

ALTER TABLE [dbo].[T_TANULOERTEKELES] WITH CHECK CHECK CONSTRAINT [FK_4025641_4028206];

ALTER TABLE [dbo].[T_TANULOERTEKELES] WITH CHECK CHECK CONSTRAINT [FK_4025641_4028210];

ALTER TABLE [dbo].[T_TANULOERTEKELES] WITH CHECK CHECK CONSTRAINT [FK_4025641_4028211];

ALTER TABLE [dbo].[T_TANULOERTEKELES] WITH CHECK CHECK CONSTRAINT [FK_4025641_4028214];

ALTER TABLE [dbo].[T_TANULOERTEKELES] WITH CHECK CHECK CONSTRAINT [FK_4025641_4028215];

ALTER TABLE [dbo].[T_TANULOERTEKELES] WITH CHECK CHECK CONSTRAINT [FK_4025662_4025660];

ALTER TABLE [dbo].[T_TANULOERTEKELES] WITH CHECK CHECK CONSTRAINT [FK_4025665_4025663];

ALTER TABLE [dbo].[T_TANULOERTEKELES] WITH CHECK CHECK CONSTRAINT [FK_4025668_4025666];

ALTER TABLE [dbo].[T_TANULOERTEKELES] WITH CHECK CHECK CONSTRAINT [FK_4025670_4025669];

ALTER TABLE [dbo].[T_TANULOERTEKELES] WITH CHECK CHECK CONSTRAINT [FK_4025938_4025937];

ALTER TABLE [dbo].[T_TANULOERTEKELES] WITH CHECK CHECK CONSTRAINT [FK_4028462_4028461];

ALTER TABLE [dbo].[T_TANULOERTEKELESLATTAMOZAS] WITH CHECK CHECK CONSTRAINT [FK_4028054_4028052];

ALTER TABLE [dbo].[T_TANULOERTEKELES] WITH CHECK CHECK CONSTRAINT [FK_4028380_4028379];


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_OSSZEFUGGOSZAKGYAK', 'T_OSSZEFUGGOSZAKGYAK_OSSZES',
					 'T_TANULOERTEKELES', 'T_TANULOERTEKELES_OSSZES',
					 'T_TANEV', 'T_TANEV_OSSZES',
					 'T_OSZTALY', 'T_OSZTALY_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


--------------------


EXEC dev.sp_Global_GenerateAsyncAuditTriggerAll
GO

EXEC dev.sp_Global_GenerateAsyncAuditProcedureAll
GO

EXEC dev.sp_Global_GenerateAsyncAuditAuditPocessing
GO

ALTER QUEUE auditLog.[AuditQueue]
WITH ACTIVATION
( 
    STATUS = ON,
    PROCEDURE_NAME = auditLog.usp_AuditProcessing,
    MAX_QUEUE_READERS = 10,
    EXECUTE AS 'Kreta_tech_user'
);

GO

