Error 2601



Message text

Attempt to insert duplicate key row in object '%.*s' with unique index '%.*s'%S_EED


No two rows can have the same index value (including NULL) in a column or columns with a unique index. Adaptive Server checks for duplicate values when the index is created (if data already exists) and checks each time data is added with an insert or update. Error 2601 occurs when you try to put duplicate index values into a column or columns with a unique index.


Using a unique index makes sense only when uniqueness is a characteristic of the actual data. Choose one of the following solutions, depending on whether you need a unique index:

Additional information

Refer to “create index” in the Reference Manual: Commands for information.

Versions in which this error is raised

All versions