Truncate a table on cascade and reset all hierarchic sequences with 1 .Maui 7 years ago TRUNCATE schema.mytable RESTART IDENTITY CASCADE;