CREATE PROCEDURE SP_Zhanr_Del
	@ID_ZHANR INT
AS
BEGIN
	DELETE
	FROM Zhanr
	WHERE @ID_ZHANR = ID_ZHANR
END
GO

..................................................
CREATE PROCEDURE SP_Proizvoditel_Del
	@ID_PROIZV INT,
AS
BEGIN
	DELETE
	FROM Proizvoditel
	WHERE @ID_PROIZV = ID_PROIZV
END
GO

..................................................
CREATE PROCEDURE SP_Vozrast_Del
	@ID_VOZR  INT,
AS
BEGIN
	DELETE
	FROM Vozrast
	WHERE @ID_VOZR = ID_VOZR
END
GO

..................................................
CREATE PROCEDURE SP_Zal_Del
	@ID_ZAL INT
AS
BEGIN
	DELETE
	FROM Zal
	WHERE @ID_ZAL = ID_ZAL
END
GO

..................................................
CREATE PROCEDURE SP_Regisser_Del
	@ID_REG INT
AS
BEGIN
	DELETE
	FROM Regisser
	WHERE @ID_REG = ID_REG
END
GO

..................................................
CREATE PROCEDURE SP_Producer_Del
	@ID_PRODUC INT
AS
BEGIN
	DELETE
	FROM Producer
	WHERE @ID_PRODUC = ID_PRODUC
END
GO

..................................................
CREATE PROCEDURE SP_Kinokompania_Del
	@ID_ KK INT
AS
BEGIN
	DELETE
	FROM Kinokompania
	WHERE @ID_ KK = ID_ KK
END
GO

..................................................
CREATE PROCEDURE SP_GLR_Del
	@ID_ GLR INT
AS
BEGIN
	DELETE
	FROM GLR
	WHERE @ID_ GLR = ID_ GLR
END
GO

..................................................
CREATE PROCEDURE SP_Film_Del
	@ID_FILM VARCHAR(36)
AS
BEGIN
	DELETE
	FROM Film
	WHERE @ID_FILM = ID_FILM
END
GO

..................................................
CREATE PROCEDURE SP_Afisha_Del
	@ID_AFISHA VARCHAR(36)
AS
BEGIN
	DELETE
	FROM Afisha
	WHERE @ID_AFISHA = ID_AFISHA
END
GO

..................................................