• Two more questions I've had for some time.

    Are table and column check constraints actually different or is it just a semantic difference? And do they fire differently?

    Do FOREIGN KEYS fire in any particular order? I use CASCADE DELETEs extensively.