Multiple choice technology programming languages

Can you call a stored function in the constraint of a table?

  1. True

  2. False

Reveal answer Fill a bubble to check yourself
B Correct answer
Explanation

Most database systems do not allow calling stored functions within table constraints like CHECK constraints. This is because constraints must be deterministic and schema-bound - they cannot rely on user-defined functions that might change or have side effects. Constraints are validated during query optimization and execution planning, where stored function calls would introduce complexity and potential performance issues.