/SQL/Postgresql truncate cascade restart identity

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 vote145 views1 answer
No query unable to fetch row sqlite
SQL
0 vote141 views1 answer
Postgresql linux password
SQL
1 vote82 views1 answer
Metada in sql
SQL
1 vote140 views1 answer
How to select multiple columns from different tables in mysql
SQL
1 vote107 views1 answer
Pentaho + pasar de excel a sql
SQL
1 vote134 views1 answer
Age postgres
SQL
0 vote128 views1 answer
How to install postgresql on wsl
SQL
1 vote143 views3 answers
Mysql on delete set null
SQL
0 vote134 views1 answer
Const pool = mysql.createpool()
SQL
2 votes129 views2 answers
Mysql find max value row
SQL