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 vote153 views1 answer
How convert into in in sql query
SQL
0 vote134 views1 answer
Horizontal join sqlite
SQL
0 vote89 views1 answer
Mysqli or pdo
SQL
0 vote125 views3 answers
ChAnge TABLE name apex oracle
SQL
0 vote132 views1 answer
How to use sqlcommand
SQL
2 votes154 views1 answer
Oracle kill session by sql_id
SQL
9 votes131 views4 answers
Mysql show table fields
SQL
0 vote155 views1 answer
Mysql dump with table query
SQL
1 vote129 views2 answers
Grab part of a string sql
SQL
0 vote128 views1 answer
Postgresql like
SQL