I am having problems creating foreign keys. I include them in the "create table" text but they do not appear on table when I do a "describe table" query

I use (for example) this text

create table departamento
(dept char(4) not null,
dedif char(3) not null,
ddespacho integer not null,
dchfno char(3),
primary key (dept))

create table curso
(cno char(4) not null,
cnombre char(22) not null,
cdescp char(25) not null,
cred integer not null,
ctarifa numeric not null,
cdept char(4) not null,
primary key (cno),
foreign key (cdept) references departamento (dept))

What am I doing wrong?

Thanks in advance

mysql does not support foreign keys unless you use innodb tables

What should I do in order to use innodb tables?

You have to select InnoDB Storage engine in configuration of schema/table.

try that,

-Nanc

You have to select InnoDB Storage engine in configuration of schema/table.
[which is in mysql administrator]
there are 5-6 different kind of engines available in mysql, you choose InnoDB and you are covered.
Still after changing to InnoDB If you dont see foreign key, I guess you recreate tables.
try that,

-Nanc