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

15 votes142 views2 answers
How to drop database name in postgresql
SQL
0 vote143 views1 answer
Vs 2019 connect to local mysql database
SQL
0 vote136 views1 answer
Sql change date format
SQL
0 vote130 views1 answer
Sql string length postgresql
SQL
0 vote168 views1 answer
Find wordpress version in database
SQL
1 vote136 views1 answer
Sql delete all values in a column
SQL
1 vote101 views1 answer
Into sql
SQL
0 vote140 views1 answer
Why mysql is used?
SQL
4 votes143 views3 answers
Employee name starting with in sql
SQL
0 vote155 views1 answer
Snowflake drop column
SQL