Restart identity cascade

Postgresql truncate cascade restart identity

TRUNCATE bigtable, fattable RESTART IDENTITY;

Source: postgresql.org

Restart identity cascade

TRUNCATE <table_name> RESTART IDENTITY CASCADE;
--RESTART will reset the identity sequence
--CASCADE all tables that have a foreign key reference to 
--table_name will be truncated as well

Similar codes

0 vote319 views1 answer
Rabbitmq ui not working
SQL
0 vote313 views1 answer
Heidisql check how much space a row
SQL
4 votes324 views2 answers
Linq join
SQL
1 vote293 views1 answer
Sequence item 6 expected str instance bytes found mysql workbench
SQL
0 vote345 views2 answers
Oracle chain rules
SQL
4 votes328 views1 answer
Find tables with column name in sql
SQL
1 vote323 views1 answer
Sql group by sum with condition
SQL
0 vote325 views1 answer
Oracle create job if not exists
SQL
0 vote308 views1 answer
How to change the field size of an existing column
SQL
0 vote313 views1 answer
How to close external sql connection in laravel
SQL