[Solved] Remove an unique index from split database

[dreamquartz]

Hi All,

I need to remove an Unique Index from table tCity on City, but the database does not allow it.
See attached picture.

Update: went into the .script file, and this line creates the Index:

Code: Select all

CREATE UNIQUE INDEX "City" ON PUBLIC."tCity"("City")

.
After removal, however, this shows:

Any ideas what this means, and how to remove an index?

Dream

[Villeroy]

Removing the CREATE statement from the script file might be a mistake. Restore the database and run DROP INDEX "City" in the Tools>SQL dialog. This will actually remove the index.

[dreamquartz]

Removing the CREATE statement from the script file might be a mistake. Restore the database and run DROP INDEX "City" in the Tools>SQL dialog. This will actually remove the index.

Thank you so much.
My not so elegant way was to copy and paste the table. This causes the index to drop as well.
However it means that the Auto numbering of the PK must be re-initiated.

Dream