From: Anhaus, Thomas (thomas.anhaussap.com)
Date: Tue Mar 09 2004 - 06:44:27 CST

• Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]

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/maxdb?unsub=thomas.anhaussap.com

--
MaxDB Discussion Mailing List
For list archives: http://lists.mysql.com/maxdb

• Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]