USE [Database]

IF OBJECT_ID('[Procedures].[delete_product_attribute]', 'P') IS NOT NULL
  DROP PROCEDURE [Procedures].[delete_product_attribute];
GO
CREATE PROCEDURE [Procedures].[delete_product_attribute]
  @product_id AS INT,
  @product_attribute_id AS INT
AS
  DELETE FROM [Tables].[product_attributes]
  WHERE [product_id] = @product_attribute_id
        AND [attribute_id] = @product_attribute_id
GO