Hi,

maybe I'm missing something, but the following statement

ALTER TABLE my_table DROP PRIMARY KEY;

fails with the error message:

Index "PRIMARY_KEY_14E" belongs to a constraint

When I run

ALTER TABLE my_table ADD CONSTRAINT PK_MY_TABLE

it is working.

According to the SQL Grammer description I would expect the first
statement to work just like the second.

Is this a bug in the code or in the documentation, or am I wrong
assuming that the first statement should work?

Regards
Thomas

-- 
You received this message because you are subscribed to the Google Groups "H2 
Database" group.
To post to this group, send email to [email protected].
To unsubscribe from this group, send email to 
[email protected].
For more options, visit this group at 
http://groups.google.com/group/h2-database?hl=en.

Reply via email to