Hi all.
I'm trying to create a PRIMARY KEY on a table I've created but am not having
any success.
TABLE SCHEMA SQL = :
CREATE TABLE X (XCOL CHAR(10))
When I execute either of the below 2 ALTER TABLE commands:
ALTER TABLE X ADD CONSTRAINT PK_X PRIMARY KEY (XCOL)
or
ALTER TABLE X ADD PRIMARY KEY (XCOL)
I keep getting the following error message:
ERROR: ALTER TABLE/ ADD CONSTRAINT is not implemented for that constraint
type. (State:S1000, Native Code: 7)
Can't find anything in the documentation?
Any ideas ?
thanks.
Andy
ahm@exel.co.uk
