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 vote346 views2 answers
How to check if sqlite table exists in nodejs
SQL
26 votes336 views6 answers
Modify column name in sql
SQL
1 vote362 views1 answer
Regular expression in sql server
SQL
2 votes351 views1 answer
Column names in oracle sql
SQL
0 vote349 views1 answer
Oracle list subpartitions
SQL
2 votes340 views3 answers
3 days back in sql server
SQL
2 votes350 views1 answer
Power query concatenate
SQL
0 vote342 views1 answer
Postgresql where clause not working
SQL
1 vote365 views1 answer
Oracle datafile max size 32gb
SQL
20 votes390 views4 answers
How to find average in sql
SQL