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?

Cant delete more than 100 rows from supabase dashboard? - Supabase