/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 vote330 views1 answer
Myswql show full processlist
SQL
0 vote371 views1 answer
Unable to convert mysql date/time value to system.datetime
SQL
0 vote341 views2 answers
The metadata storage is not up to date, please run the sync-metadata-storage command to fix this issue.
SQL
0 vote289 views1 answer
Postgresql add leading zeros
SQL
1 vote389 views1 answer
Mysql view curren querys
SQL
2 votes364 views3 answers
Sql truncate table
SQL
0 vote334 views1 answer
Month mysql
SQL
0 vote341 views1 answer
Login phpmyadmin without password
SQL
0 vote364 views1 answer
How to add session data into mysql database from button
SQL
0 vote340 views1 answer
Error: connect ECONNREFUSED 127.0.0.1:5432 at TCPConnectWrap.afterConnect [as oncomplete] (net.js:1148:16
SQL