CREATE TABLE XYZ(id INT NOT NULL PRIMARY KEY CLUSTERED);
CREATE TABLE ABC(id INT NOT NULL REFERENCES XYZ(id));

INSERT INTO XYZ VALUES (1),(2),(3);
INSERT INTO ABC VALUES (1);


BEGIN TRY
	BEGIN TRAN

		DELETE FROM XYZ WHERE id = 1;
	COMMIT TRAN
END TRY
BEGIN CATCH
	-- raise error here
	ROLLBACK
END CATCH;

DROP TABLE ABC;
DROP TABLE xyz;

quote:

---

I'm doing BULK deletes from a staging table, no row-based/cursor deletions as the number of customers to delete is too large for that and time constraints prevent row-based/cursor deletions. What is the best way to do this?

---

quote:

---

Everything does delete without issues. However, "IF" I were to run into a constraint issue for whatever reason, I want to be able to catch this error.

---