Can't create index on table - MS Sql Server 2014

smirandac1978's profile image smirandac1978 posted 4 years ago in General Permalink

Hello how are you? I really like this HeidiSQL program, but I have noticed that I cannot create indexes on MS Sql Server 2014 tables. When I create one following the correct procedure, I get an error " SQL error (1750): Failed to create the constraint or index. See the previous errors. "Attached screenshots.

And I see in the command history, it tries to do an ALTER TABLE instead of a CREATE NONCLUSTERED INDEX

Is it a mistake on my part? Or is there something that can be done to fix it?

Thank you very much.

2 attachment(s):
  • h1
  • h2

Please login to leave a reply, or register at first.