knex/test/integration/migrate/async-await-drop-and-recreate-with-schema/02_drop_and_recreate.js

exports.up = async (knex) => {
  await knex.schema
    .withSchema('dummy_schema')
    .table('old_users', function (table) {
      table.dropColumn('officeId');
    });

  await knex.schema
    .withSchema('dummy_schema')
    .table('old_users', function (table) {
      table.string('officeId', 255);
    });
};

exports.down = async (knex) => {};