Apologies for the simplicity of this question, but it's driving me mad.

Can anyone tell me what is wrong with this sql statement.

create table Quote(quoteID varchar(10) primary key, customerID varchar(10) references Customer on delete restrict on update cascade, quoteDate date not null)

Yes the table Customer already exists. I've taken out "on delete restrict on update cascade" and the table is created, so obviously this part is causing the problem but I can't see why.

The error I'm getting is that a keyword is missing.

TIA
Curlydog