/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

7 votes179 views4 answers
What is my mysql version
SQL
16 votes182 views1 answer
CTE statement sql server
SQL
2 votes175 views1 answer
Drop table if exists in postgres
SQL
0 vote175 views1 answer
Firebase sql
SQL
2 votes177 views3 answers
Current month mysql query
SQL
23 votes235 views2 answers
Query to delete a database in mysql
SQL
7 votes174 views3 answers
Sql get last inserted row
SQL
0 vote178 views1 answer
Check duplicate values plsql
SQL
0 vote177 views1 answer
Fill up postgres db
SQL
4 votes179 views2 answers
Sqlalchemy_database_uri for mysql
SQL