v.23.10Improvement

Support renaming tables without the TABLE keyword

Support rename table without keyword TABLE like RENAME db.t1 to db.t2. #55373 (凌涛).
Support renaming tables using the RENAME statement without requiring the TABLE keyword, allowing syntax like RENAME db.t1 TO db.t2.

Why it matters

This feature simplifies the syntax for renaming tables by removing the mandatory TABLE keyword in the RENAME statement. It improves usability and makes the rename command more concise and easier to write.

How to use it

Users can rename tables by executing SQL commands in the following format:

RENAME db.t1 TO db.t2


This new syntax does not require the TABLE keyword previously needed, streamlining table renaming operations.