Sandy Norton wrote: > When I enter the following statement in SQLStudio: > > CREATE TABLE author > ( > author_id INTEGER, > author_first_name VARCHAR (128) NOT NULL, > author_middle_name VARCHAR (128), > author_last_name VARCHAR (128), > UNIQUE (author_id) > ) > > I get a -5006 error 'Missing identifier' even though this is clearly > permitted in the reference documentation. Am I missing something?
We have to assume that you are using kernel 7.4.3. For some internal reason up to version 7.4.3.10 the specification of a constraint_name is needed in front of UNIQUE. CONSTRAINT myuniqueconstraint UNIQUE (author_id) Starting with 7.4.3.11 the syntax mentioned above, without constraintname, is available again. Elke SAP Labs Berlin _______________________________________________ sapdb.general mailing list [EMAIL PROTECTED] http://listserv.sap.com/mailman/listinfo/sapdb.general
