to add primary key

[Andreas Ernst]

Hi,

i want to add a primary key to a table.

As i read in the documentation:

-----------------------------------------------------------------------------------------------
A key definition in a CREATE TABLE statement [Page 113] or an ALTER TABLE statement
[Page 130] defines the key in a base table. The key definition is introduced by the keywords
PRIMARY KEY.
Syntax
<key_definition> :: PRIMARY KEY (<column_name>,...)
-----------------------------------------------------------------------------------------------

So i did:

alter table server_benutzer add primary key (server)

The column server already existed.

Any hints?
regards
Andreas



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