I think maybe this is just a documentation problem, and that sentence can simply be
removed from the RENAME TABLE page in the reference guide.
Please note that the sentence says "can be renamed", not "cannot be renamed".
I think this might be confusing; people might have thought it was saying that the
table cannot be renamed if there is an index defined on it, but I think that the
documentation is correctly stating that the table can be renamed if there is an
index defined on it.
As far as I know, a table can be renamed even if it has one or more indexes on it,
and we have at least 1 regression test (in RenameTableTest.java) which verifies this.
Perhaps the best thing to do would be to re-word that sentence slightly:
Note that a table can be renamed even if it has one or more indexes defined on it;
the presence of an index defined on the table does not prevent the table from
Or, we could just remove the sentence.