How to add a new column to an existing table
Right now I have just been testing locally with Drizzle, Supabase, and Next.js... I created a schema for a table called "ballots" (see image). However, I realized that I am missing a column 🫠 🤦♂️ which is the one that is commented out in the image. Now what I have been doing is deleting the tables in Supabase along with the
supabase/migrations folder and then running the generate and migrate scripts... 😬 I feel like that is a bad thing (maybe not?)... Since I am just testing and none of this has gone to production, is that ok? Also, any idea on how to "reset" the id column in Supabase if I don't go about deleting the table?
1 Reply
same issue for me. i also intially does not think about a column but after work with several weeks i need add a new column with not null restriction. do you know how to solve this issue standard way. do not delete entire table is not good approach 😦