Define "manually generate".
CREATE TABLE newtable AS existingtable..., which allows defining indexes.
SHOW TABLE and then edit.
Thanks for your quick replay :)
I'll explain my situation.
My main goal is to run daily script which drop and create the staging table as the prod table but with some schema changes (without the columnar features).