Oh, well, that's embarassingly obvious! Thanks. Then there must be an error in my program, because it should have removed the referencing foreign keys first. Easy to verify that and I probably should have checked that. Your explanation makes absolute sense.
Best regards,
Robert
Anhaus, Thomas wrote:
Robert Kr�ger wrote :
Hi,
could someone please explain under which circumstances SAPDB throws this error? It happens from time to time when i remove a primary key from an existing table. However, the message "Key not allowed" is not very helpful. The reference docs do not say anythig but the "Key not allowed"
I'm using SAPDB 7.3.x (I think the latest maintenace release)
Thanks in advance,
Robert
The table probably is <referenced table> of a referential constraint, which references the table via the key. In this case it's not permitted to drop the key. You should drop the referential constraint first.
Best Regards, Thomas
-- ________________________ Robert Kr�ger Signal7 GmbH Br�der Knauss Str. 79 64285 Darmstadt Germany
-- MaxDB Discussion Mailing List For list archives: http://lists.mysql.com/maxdb To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
