Hi,
We do an alter on a column of a table concerned by a index.
The problem is that the index is dropped.
I understand that the ALTER on an indexed column has an impact on the index but deletion is problematic.
Thank you.
|
What's your sql? Alter table sql will result the total table structure reconstruct sometimes.
|
For example :
CREATE TABLE test (col VARCHAR(6))
CREATE INDEX testPK ON test (col UNIQUE PRIMARY KEY ASC)
ALTER TABLE test MODIFY col VARCHAR(10)
=> The index is deleted but I expected immediate re-creation
|
Supported. Please download the latest packaga.
|