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