is any solution to rename column?
It is not easy to do this automatically, so no. Sqlite doesn't have support for it, so there's little we can do here. Workarounds exist by
INSERT INTO SELECT statementSome queries that could be used to achieve this are described in this StackOverflow answer. You can use issueCustomQuery on the migrator to execute them.
If you only want to rename the column, I would actually recommend to rename it in Dart and keep the old sql name. So for instance,
IntColumn myFancyColumn => integer()...();
could be renamed with
IntColumn myRenamedColumn => integer().named('my_fancy_column')...();
Most helpful comment
It is not easy to do this automatically, so no. Sqlite doesn't have support for it, so there's little we can do here. Workarounds exist by
INSERT INTO SELECTstatementSome queries that could be used to achieve this are described in this StackOverflow answer. You can use
issueCustomQueryon the migrator to execute them.If you only want to rename the column, I would actually recommend to rename it in Dart and keep the old sql name. So for instance,
could be renamed with