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 vote191 views1 answer
Mysql count unique in group statement
SQL
0 vote219 views1 answer
Oracle date summer time
SQL
0 vote209 views1 answer
Sql remove non numeric characters
SQL
0 vote198 views1 answer
Mysql workbench primary key
SQL
0 vote186 views1 answer
Select from another database
SQL
2 votes278 views2 answers
Set value to null sql
SQL
11 votes188 views2 answers
Mysql set safe mode off
SQL
0 vote197 views1 answer
Sql query for displaying age from oldest to youngest
SQL
0 vote204 views1 answer
Mysql grant grant option
SQL
0 vote209 views1 answer
Add mysql database to power bi web
SQL