Β© 2026 Hedgehog Software, LLC

TwitterGitHubDiscord
More
CommunitiesDocsAboutTermsPrivacy
Search
Star
Setup for Free
Drizzle TeamDT
Drizzle Teamβ€’2y agoβ€’
1 reply
jsingleton37

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
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
id
column in Supabase if I don't go about deleting the table?
image.png
Drizzle TeamJoin
The official Discord for all Drizzle related projects, such as Drizzle ORM, Drizzle Kit, Drizzle Studio and more!
11,879Members
Resources

Similar Threads

Was this page helpful?
Recent Announcements

Similar Threads

posible to add a serial column in a existing table? (PGtable)
Drizzle TeamDTDrizzle Team / help
10mo ago
[SOLVED] How to add new column?
Drizzle TeamDTDrizzle Team / help
3y ago
β€œIf does not exist” for migration schemes and add a column to an existing table
Drizzle TeamDTDrizzle Team / help
16mo ago
Adding unique() to an existing table in Supabase
Drizzle TeamDTDrizzle Team / help
6mo ago