/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 vote302 views1 answer
Insert to first table if field A equals field B from a second table using sql
SQL
1 vote339 views1 answer
How to test for sql injection
SQL
0 vote334 views1 answer
Find usage of table in sql server
SQL
0 vote309 views1 answer
Sqlite select split string
SQL
0 vote314 views1 answer
Denormalise SQL command
SQL
-2 votes318 views1 answer
Modify column name in tsql
SQL
0 vote326 views1 answer
Substract variable amount of minutes from timestamp postgresql
SQL
0 vote303 views1 answer
Create table employees oracle
SQL
0 vote307 views1 answer
Search db for table name
SQL
0 vote323 views1 answer
How to concatenate text from multiple rows into a single text string in SQL Server
SQL