Truncate a table on cascade and reset all hierarchic sequences with 1

TRUNCATE schema.mytable RESTART IDENTITY CASCADE;

Leave a Comment

Your email address will not be published. Required fields are marked *