Database

employee_benefit_id --- autonumber
employee_id
benefit_category
benefit_description
benefit_amount

salary_slip_id --- autonumber
document_id ---- forget this it's just UUID
employee_id -- from employee_id in employee_benefits
slip_month -- from SP variable param_slip_month
slip_year -- from SP variable param_slip_year

salary_slip_details_id --- autonumber
salary_slip_id  -- the id from salary_slips table
slip_details_description -- benefit_description from employee_benefits table
slip_details_amount -- benefit_amount from employee_benefits table

DECLARE @ConstraintName nvarchar(200);
DECLARE @TableName nvarchar(500)='ApplicationData';
DECLARE @ColumnName nvarchar(500)='ReportingFpl';

SET NOCOUNT ON
   SET xact_abort ON
   WHILE 0=0 BEGIN      
      SET @constraintName = (
         SELECT TOP 1 constraint_name
            FROM information_schema.constraint_column_usage
            WHERE table_name = @tableName and column_name = @columnName );
      IF @constraintName is null BREAK;
      EXEC ('alter table "'+@tableName+'" drop constraint "'+@constraintName+'"');
	END

ALTER TABLE dbo.ApplicationData DROP COLUMN ReportingFpl;
GO

Msg 5074, Level 16, State 1, Line 16
The index 'IX_ApplicationData_ApplicationId-ReportingFpl_PriorityPoints-ContractorPriorityPoints' is dependent on column 'ReportingFpl'.
Msg 4922, Level 16, State 9, Line 16
ALTER TABLE DROP COLUMN ReportingFpl failed because one or more objects access this column.