/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

11 votes169 views2 answers
Oracle saurce code
SQL
3 votes161 views2 answers
Df to sql pandas sql achemy
SQL
3 votes168 views1 answer
Force using index plsql
SQL
3 votes153 views1 answer
Only join in sql
SQL
1 vote158 views1 answer
OstgreSQL version
SQL
0 vote154 views1 answer
Sql query to delete row by id
SQL
0 vote157 views1 answer
Https://livesql.oracle.com/apex/livesql/s/l8fedwph53gt5gigbacwvu6m0
SQL
0 vote152 views1 answer
Jenkins SQLCMD run
SQL
1 vote212 views1 answer
Postgres set sequence value to max id
SQL
1 vote158 views2 answers
How to drop a unique constraint in sql
SQL