Hi Kaushik,
You can Create History Table that is photicopy of Orginal table But have no constraint
and insert into historical table befor delete this row as
insert into Hst_TBL1
SELECT * FROM TBL1
where TBL1_Id = @Id
then delete record you want
delete from TBL1 where TBL1_Id = @Id