TSQL: How to DELETE in cascade without altering table / indexes
Perhaps simply do it manually with two deletes, in a transaction to ensure consistency:

BEGIN TRANSACTION
DELETE T2 WHERE employeeID IN (SELECT employeeID FROM T1 WHERE &lt;clauses_to_find_the_records_to_delete&gt;
DELETE T1 WHERE &lt;clauses_to_find_the_records_to_delete&gt;
COMMIT TRANSACTION


You might want to add that FK constraint anyway, with or without the cascade options (I very much prefer without cascade, so still needing the manually ordered deletes, it is very convenient in some cases but adds dangers...), if it is correct for your data model.