Re: Dropping foreign key constraint

Hey, thanks for your reply Jennie, but what about the other variant with 'constraint'. It generally is more about the 'alter statements' than the 'drop statements'... In general: how do you maintain your productive schemas? You don't seem to use the SQL interface - but which other interface should I use instead? Best regards, Alex

Am 04.01.2016 um 22:44 schrieb Ying Zhang :

...

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

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