uncheck constraints and delete from table
alter table MyOtherTable nocheck constraint all delete from MyTable alter table MyOtherTable check constraint all
Source: stackoverflow.com
alter table MyOtherTable nocheck constraint all delete from MyTable alter table MyOtherTable check constraint all