Agree not to putting your business logic in stored procs, but hard neg on getting rid of all constraints. I consider it defense in depth. Sure your application

Agree not to putting your business logic in stored procs, but hard neg on getting rid of all constraints. I consider it defense in depth. Sure your application should absolutely ensure order lines aren't referencing a non-existing order, but bugs happen and I prefer the database returning an error to the database getting full of inconsistent data.