ยฉ 2026 Hedgehog Software, LLC

TwitterGitHubDiscord
More
CommunitiesDocsAboutTermsPrivacy
Search
Star
Setup for Free
SupabaseS
Supabaseโ€ข4y agoโ€ข
3 replies
LukasV

Cant delete more than 100 rows from supabase dashboard?

I have 2 questions:
I am trying to delete all selected rows from my table, but I get this error:

Failed to run sql query: cannot truncate a table referenced in a foreign key constraint
Failed to run sql query: cannot truncate a table referenced in a foreign key constraint


Another question is - how do I reset the row count back to 1?
Screenshot_2022-09-21_at_18.23.49.png
Supabase banner
SupabaseJoin
Supabase gives you the tools, documentation, and community that makes managing databases, authentication, and backend infrastructure a lot less overwhelming.
45,816Members
Resources

Similar Threads

Was this page helpful?
Recent Announcements

Similar Threads

Can't delete users from dashboard
SupabaseSSupabase / help-and-questions
7mo ago
Delete Lovable.dev access from Supabase
SupabaseSSupabase / help-and-questions
7mo ago
Delete rows in Supabase but table size stays the same?
SupabaseSSupabase / help-and-questions
7d ago
supabase dashboard down
SupabaseSSupabase / help-and-questions
13mo ago