I think, the two formats you raised are both that of
foreign key constraint:
when there is a composite foreign key (more than 1
attribute in a table involved), you must use foreign
key clause.
if there is only a simple foreign key, you can use
either format.
--- Egor Egorov [EMAIL PROTECTED]
Mysql 4.0.12 on win xp.
Question: is the check constraint supported?
Example:
create table temp (
c1 varchar (50) check (c1 like [EMAIL PROTECTED])
);
insert into temp values (whatever);
will succeed. Is my constraint wrong (say to check the
email address)? or this is just parsed without