Files
2024-03-13 00:33:46 +01:00

15 lines
380 B
Transact-SQL

DELETE FROM T_JOGOSULTSAG WHERE C_SZEREPKORTIPUS = 1759
GO
DELETE FROM T_JOGOSULTSAG_FELHASZNALO WHERE C_JOGOSULTSAGID in (SELECT ID FROM T_JOGOSULTSAG WHERE C_SZEREPKORTIPUS = 1759)
GO
DELETE FROM T_SZEREPKOR WHERE C_SZEREPKORTIPUS = 1759
GO
DELETE FROM T_SZEREPKORTIPUS WHERE ID = 1759
GO
DELETE FROM T_DICTIONARYITEMBASE WHERE ID = 1759 AND C_TYPE = 'SzerepkorTipus'
GO