James Anderson shows that delete statements will ignore check constraints:
I know it sounds a bit odd but DELETE statements really do ignore table constraints. Running the code below in a test database will setup a test to prove this.
James gives a couple pieces of advice on how to implement this scenario if you find yourself needing to do something like this.