Skip to content

Can't drop indexes from SQLite tables #1605

@timint

Description

@timint

Preconditions
HeidiSQL 12.0.0.6468
Windows 11 64-bit

Describe the bug
Removing an index key causes a malfunction.

To Reproduce
Remove an index, click Save.
This produces the following query:
ALTER TABLE "dummy" DROP .......;

Screenshots or Crash reports
image

Documentation:
https://www.sqlitetutorial.net/sqlite-index/

Metadata

Metadata

Assignees

No one assigned

    Labels

    bugDefective behaviour in HeidiSQLnettype-sqliteSQLite specific issue

    Type

    No type

    Projects

    No projects

    Milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions