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 vote190 views1 answer
Mysql min value row
SQL
0 vote168 views1 answer
Sql check for null and empty string
SQL
1 vote188 views2 answers
How to install sql server management studio in ubuntu 18.04
SQL
0 vote174 views1 answer
Https://livesql.oracle.com/apex/livesql/s/l8fedwph53gt5gigbacwvu6m0
SQL
0 vote221 views1 answer
Mql5 datetime get hour
SQL
0 vote166 views1 answer
Mariadb number format
SQL
13 votes193 views1 answer
Sql join 3 tables on id
SQL
7 votes173 views4 answers
What is my mysql version
SQL
0 vote173 views1 answer
How to reset the database value in SQL server
SQL
1 vote144 views1 answer
Unique vs distinct sql
SQL