Re: Dropping foreign key constraint

On Jan 04, 2016, at 20:05, Alexander Gordt wrote:

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??

Hai Alex, I checked our SQL grammar (see sql_parser.y) and the monetdb.org documentation of DROP statement [1], this syntax indeed seems to be unsupported… Regards, Jennie [1] https://www.monetdb.org/Documentation/Manuals/SQLreference/DropStatement

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

_______________________________________________ users-list mailing list users-list@monetdb.org https://www.monetdb.org/mailman/listinfo/users-list