Comment by Footkerchief

You still use constraints even if you put all your business logic in stored procedures.