471,083 Members | 1,066 Online
Bytes | Software Development & Data Engineering Community
Post +

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 471,083 software developers and data experts.

Constraint

1)I'm tring to create a new table but the creation fails because I
insert as a wrong sintax the keyword 'constraint'.

For example...
TABLE xxxx
field 1 cod
field 2 name
field 3 is_died (boolean)
field 4 died_date (date)
I would like to chek if is_died == true then died_date must not has
NULL value and viceversa if is_died == false then died_date must has
NULL value.

2) I would like manage constraint between two table but I have no idea
about it.
Can you help me? Do you have some example???

Thank in advance Estevan

Please don't use the mail you can watch at the top of the forum
Jul 20 '05 #1
0 1092

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

26 posts views Thread by Agoston Bejo | last post: by
4 posts views Thread by wireless | last post: by
10 posts views Thread by Laurence | last post: by
2 posts views Thread by Kenneth Koenraadt | last post: by
15 posts views Thread by Frank Swarbrick | last post: by

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.