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