SQL in constraints

From: <mgumbs_at_hotmail.com>
Date: Mon, 01 Mar 1999 17:10:19 GMT
Message-ID: <7behli$p5n$1@nnrp1.dejanews.com>

Is it possible to use SQL in constraints?

e.g Create table football.....

...
...

      Constraint rs_football_name
            check name in (select name from register where....)

If not, are there any alternatives? I have thoought of a pre-insert trigger but is there anything else?

Replies by e-mail if poss.

Mark

-----------== Posted via Deja News, The Discussion Network ==---------- http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own Received on Mon Mar 01 1999 - 11:10:19 CST