Stored programs should be checked for consistency with existing table definitions at the time of CREATE; alteration of the schema should re-check the consistency of stored programs. Getting run-time errors for what should be checked at ‘compile time’ is balderdash.
The blog of Brian L. Troutwine.
June 21, 2011
Relational Database Implementation Problem: 1