Drizzle Team•7d ago

Renaming Table with push

I use push for migrations, which I understand is not the most recommended way to handle migrations. I'm trying to rename a table, but the push command always asks if I want to create a new table on rename the existing one:

Is products table created or renamed from another table?
❯ + products                         create table
  ~ product › products rename table

Is products table created or renamed from another table?
❯ + products                         create table
  ~ product › products rename table

Is there a way for me to pre-select the rename option so that my push migration works on CI? Or do I really need to do the traditional migration? The "normal" migrations won't work for me due to the fact I never used them, so it tries to recreate a table that already exists since drizzle doesn't add the IF NOT EXISTS statement (pretty old problem with drizzle)

0 Replies

No replies yetBe the first to reply to this messageJoin

Gaming

Programming

Renaming Table with push