/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 votes202 views1 answer
Connect mysql docker
SQL
21 votes224 views1 answer
SQL cheat sheet pdf
SQL
1 vote217 views1 answer
Top 10 rows in mysql
SQL
0 vote217 views1 answer
Mysql date equals to current_date plus days
SQL
0 vote234 views1 answer
Sql cursor example multiple columns
SQL
1 vote220 views1 answer
Ora-01109 database not open in oracle 19c
SQL
0 vote205 views2 answers
Wordpress change url in database
SQL
1 vote202 views1 answer
Add current timestamp in mysql
SQL
0 vote201 views1 answer
Forcefully delete a row in mysql which has references
SQL
1 vote219 views1 answer
Oracle grant select on schema
SQL