Adding a primary key to a table

[williamkimber]

Hi i'm having trouble with adding a primary key to a pre created table.

The syntax below is what i'm using to add a primary key to my university table

ALTER TABLE UNIVERSITY ADD CONSTRAINT UNIVERSITY PK PRIMARY KEY(U_PK);

The error i get is INVALID TABLE COMMAND

Can anybody help?

Many thanks!!

[stepterr]

Here's an example of the syntax.

ALTER TABLE Customer ADD PRIMARY KEY (SID);

[Jerry Winston]

Notice the blank space characters in you primary key name "University PK". SQL is expecting a single name. You could add an under score like :

ALTER TABLE UNIVERSITY ADD CONSTRAINT UNIVERSITY_PK PRIMARY KEY(U_PK);

or enclose the key name in brackets:

ALTER TABLE UNIVERSITY ADD CONSTRAINT [UNIVERSITY PK] PRIMARY KEY(U_PK);

Also, take a look at stepterr's syntax. I think you don't intend CONSTRAINT to be part of the primary key name. SQL is trying to use it as a keyword to build the key.