the following raises error:150. Does this mean we cannot do this in INNODB format?
create table t1 (a1 integer not null, b1 varchar(36), primary key (a1), foreign key (b1) references t2(b1) on delete cascade) TYPE=INNODB regards ____________________________________________________________ Yahoo! Messenger - Communicate instantly..."Ping" your friends today! Download Messenger Now http://uk.messenger.yahoo.com/download/index.html -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]