Re: Which rows broke my constraint?

Lee,

It sounds as if you have a situation where you need more than one index?

Would things work if you had a primary key, and one or more unique keys?

As in
ALTER TABLE DAYTYPE ADD CONSTRAINT PK_DAYTYPE PRIMARY KEY
(DAYTYPE_1, DAYTYPE);

ALTER TABLE DAYTYPE ADD CONSTRAINT UK_DAYTYPE UNIQUE
(DAYTYPE, LINENO);
Best regards
Henrik Received on Wed Sep 09 1998 - 07:42:04 CDT