Hello together,

I’m very new to MonetDB, so please be gracious :)
I’m trying to drop a foreign key, what should be a very simple task – but I didn’t manage to do it.

The following statement ran successfully – as the result says – but the foreign key is still there:

alter table visit drop constraint visit_configuration_id_fkey;

I also tried this – but this command is not supported??

alter table visit drop foreign key visit_configuration_id_fkey;

An error occurred when executing the SQL command:
alter table visit drop foreign key visit_configuration_id_fkey

syntax error, unexpected FOREIGN in: "alter table visit drop foreign" [SQL State=42000]

Execution time: 0.01s
1 statement failed.

Best regards and thanks for any hints,

Alex