/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 vote150 views1 answer
Intellij idea add mysql connector
SQL
2 votes132 views1 answer
Get first 3 letters name in sql
SQL
1 vote98 views1 answer
How to run sql script
SQL
3 votes138 views1 answer
Sql server version query
SQL
6 votes124 views5 answers
Get current date sql
SQL
8 votes151 views1 answer
Oracle search text in all packages
SQL
0 vote139 views1 answer
Mysql join same table multiple times group by
SQL
1 vote134 views2 answers
String to date postgres
SQL
0 vote150 views1 answer
Psql check if sql script is valid
SQL
0 vote138 views1 answer
Flask sqlalchemy. commit does not save changes
SQL