thanks for you answers. Sorry for the late answer, but i was in a meeting.
On this table i had a primary key and wanted to add a second.
I my opinion this should work.....
So i drop the primary key
alter table server_gruppen drop primary key
and added ( the old and the new)
alter table server_gruppen add primary key (nr,server)
Maybe, Elke, you about this, i think to add a primary key to an existing primary key should work.
I think it will be nicer to do this in one step instead of two...;-))))
regards
Andreas
Sven Koehler schrieb:
i want to add a primary key to a table.
if the table already has a primary key defined, you cannot change it.
if the table doesn't have any primary column, it should be abled to add a primary key, but i think this isn't possible.
i think i read the docs somewhere, that altering the primary key is not possible, but i'm not quite sure.
_______________________________________________
sapdb.general mailing list
[EMAIL PROTECTED]
http://listserv.sap.com/mailman/listinfo/sapdb.general
_______________________________________________ sapdb.general mailing list [EMAIL PROTECTED] http://listserv.sap.com/mailman/listinfo/sapdb.general
