SET QUOTED_IDENTIFIER ON

GO

-- ============================================================================
-- Release migration (#2347): remove Impact from mechanical results only.
-- Drops the column BEFORE the DACPAC publish so the schema diff has no
-- data-loss drop to block. Idempotent: skips the column if already removed.
-- NOTE: Impact stays in LAB.TensileRequirementsByGrade (still configured/used).
-- ============================================================================
IF COL_LENGTH('LAB.HeatMechanicalResults', 'ImpactValue') IS NOT NULL
    ALTER TABLE LAB.HeatMechanicalResults DROP COLUMN ImpactValue;
GO
