soory,
i forgot to send the email to the list...

Peter Willadt schrieb:

Hello,

Are you sure you didn't mean
create unique index server on table(server)
instead of
alter table server_gruppen add primary key (server)
??

yes, i needed two primary key


are you shure?
To me this is completely uncomprehensible.
A unique key is distinct in any record.
A primary key also is, but in sapdb it also serves for physically ordering the records. Probably, at one time records can be ordered only one way.
So what else could a second primary key be good for in any way that a unique index can not do?

Peter Willadt



Hi Peter,

Sven sendet an email direct to, and it is now clear.
On a table there con only be __one__ primary key.
I wanted to add a second column to the primary key, for this entries in
the table:

  1 1
  1 2
  2 1
  2 2

regards
Andreas




_______________________________________________
sapdb.general mailing list
[EMAIL PROTECTED]
http://listserv.sap.com/mailman/listinfo/sapdb.general

Reply via email to