/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

4 votes176 views2 answers
Mysql alter table set column unique
SQL
0 vote112 views1 answer
Separator mysql
SQL
8 votes143 views1 answer
Mysql limit rows
SQL
0 vote217 views3 answers
Insert or ignore postgres
SQL
4 votes135 views1 answer
Mysql not equal
SQL
0 vote147 views1 answer
Mysql regex select
SQL
0 vote132 views1 answer
Mssql now diff 90 day
SQL
2 votes146 views1 answer
Oracle drop sequence if exists
SQL
1 vote134 views2 answers
Update with inner join sql server
SQL
0 vote142 views1 answer
Sp in sql server
SQL