/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 vote128 views1 answer
Myswql show full processlist
SQL
1 vote148 views1 answer
Sql server: query to find out all the places where the table is used
SQL
1 vote127 views4 answers
Between vs in sql
SQL
8 votes133 views2 answers
Update sql server from another table
SQL
0 vote146 views1 answer
How to select even id in sql
SQL
7 votes141 views1 answer
Buy forge mods server hosting
SQL
4 votes140 views1 answer
Mac install mysql
SQL
4 votes145 views5 answers
Primary key
SQL
0 vote137 views1 answer
Comparing with today and yesterday record in sql query
SQL
1 vote145 views2 answers
Postgresql remote connect
SQL