SET QUOTED_IDENTIFIER ON
GO
SET ANSI_NULLS ON
GO
CREATE procedure [dbo].[p_test_family_delete]
	@family_code ais_code_short
as

	delete	pr_families_natures
	where	pfn_family_code = @family_code

	delete	pr_families_formulas_variables
	where	pffv_family_code = @family_code

	delete	pr_families_variables
	where	pfv_family_code = @family_code

	delete	pr_families_formulas
	where	pff_family_code = @family_code

	delete	pr_families_cies
	where	prfc_family_code = @family_code

	delete	pr_families
	where	pf_family_code = @family_code
GO
