T-SQL Tutorial

Msg 1913 Level 16 - The operation failed because an index


Transact sql error message Msg 1913 Level 16 - The operation failed because an index or statistics with name already exists on table.

Msg 1913 Level 16 Example:


GO
CREATE INDEX test_idx_1 ON test_table (id)
GO

Message
Command(s) completed successfully.

Create index with existing name:


GO
CREATE INDEX test_idx_1 ON test_table (id)
GO

Message
Msg 1913, Level 16, State 1, Line 26
The operation failed because an index or statistics with name 'test_idx_1' already exists on table 'test_table'.

Other error messages: