Is is possible to create a check constraint across the tables.

[elza]

You can create a table check constriant for this.

Check this link for more details:

http://www.ibm.com/developerworks/db2/library/techarticle/dm-0401melnyk/index.html

[Knut Stolze]

Post by elza
You can create a table check constriant for this.

"table check constraint" is not a very good name. Those things are
rather "row check constraints". You can only refer to constants and the
values in a single row in the constraint - no other table or other rows of
the same table.