Add Constraint Syntax 1

[markedback]

I have a table with no primary key.

I want to assign a primary key to a field with ID numbers.

I tried the following ALTER table syntax >>

ALTER TABLE [table name] ADD CONSTRAINT [ID number] UNIQUE

('ID number' is the column name I want to make the primary key)

I keep getting this error >>

"syntax error in CONSTRAINT clause"

Please suggest the correct syntax.

Thanks in advance,
Mark.

 

[PHV]

ALTER TABLE [table name] ADD CONSTRAINT [constraint name] UNIQUE ([ID number])

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[markedback]

It worked!

Thanks a lot PHV!