/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

3 votes200 views1 answer
Only join in sql
SQL
0 vote313 views1 answer
Python get backup of sql
SQL
5 votes195 views1 answer
How to check nls timestamp format in oracle
SQL
0 vote213 views1 answer
New rails app with mysql
SQL
2 votes227 views1 answer
Sql server find columns list in tables
SQL
8 votes234 views1 answer
My sql version
SQL
0 vote219 views2 answers
Postgres show current role
SQL
0 vote263 views1 answer
Many rows to 1 string mysql
SQL
2 votes197 views2 answers
Created at and updated at in mysql
SQL
0 vote242 views1 answer
How to check oracle index table
SQL