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

Question

I would like to know whether we can call a stored function in a constraint of a table ? Thank you

Answer 1

0

Yes. For example:

ALTER TABLE emp ADD CONSTRAINT caseCheckConstraint CHECK ( UPPER(ename)=ename )

Uses the UPPER function in a check constraint.

answered Jan 11 '10 at 01:32 PM

Andrew Mobbs
1.5k ● 1 ● 3

(comments are locked)

Answer 2

0

Unless it is an user-defined function.

answered Jan 07 '11 at 03:49 PM

(comments are locked)