So i drop the primary keyA key connot be altered - only dropped and re-created.
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...;-))))
That doesn't apply to primary keys only, but also to unique or normal indexes.
the two statements:
alter table server_gruppen add primary key (nr)
alter table server_gruppen add primary key (server)
have a different meaning than
alter table server_gruppen add primary key (nr,server)
the first two statements create _two_ keys of one column each
the third statement creates _one_ key of _two_ columns
I don't agree with you to include support for "adding a primary key to another". That doesn make any sense.
Are you sure you didn't mean
create unique index server on table(server)
instead of
alter table server_gruppen add primary key (server)
??
_______________________________________________
sapdb.general mailing list
[EMAIL PROTECTED]
http://listserv.sap.com/mailman/listinfo/sapdb.general
