Ads were blocked - no problem. But keep in mind that developing HeidiSQL, user support and hosting takes time and money. You may want to send a donation instead.

Does HeidiSQL support MS SQL 2005 fully? add index to a table...

smartree's profile image smartree posted 5 years ago in HeidiSQL portable Permalink

first, when I add two index to a table, cannot execute the alter script with error: --SQL错误(1018):Incorrect syntax near 'INDEX'. If this is intended as a part of a table hint, A WITH keyword and parenthesis are now required. See SQL Server Books Online for proper syntax.

second, so I use the CREATE INDEX script manually, it can add index successfully, but cannot refresh the Index tab to see the new indexes.

cause the table use sql: SELECT C.CONSTRAINT_NAME, C.CONSTRAINT_TYPE, K.COLUMN_NAME FROM INFORMATION_SCHEMA.TABLE_CONSTRAINTS AS C INNER JOIN INFORMATION_SCHEMA.KEY_COLUMN_USAGE AS K ON C.CONSTRAINT_NAME = K.CONSTRAINT_NAME AND K.TABLE_NAME='AcvB_AccessLog' AND K.TABLE_SCHEMA='dbo' WHERE C.CONSTRAINT_TYPE IN ('PRIMARY KEY', 'UNIQUE') ORDER BY K.ORDINAL_POSITION;

1 attachment(s):
  • HeidiSQL9portable-mssql2005-index

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




Ads were blocked - no problem. But keep in mind that developing HeidiSQL, user support and hosting takes time and money. You may want to send a donation instead.