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