/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 vote189 views1 answer
Postgre admin slow
SQL
0 vote206 views1 answer
SQL Server rename foreign key constraint
SQL
0 vote193 views1 answer
Test the postgresql db connection
SQL
0 vote207 views1 answer
How to get first 10 records of a table in mysql
SQL
0 vote206 views1 answer
Change database name psql 8
SQL
1 vote195 views1 answer
Grab all records from one table to another oracle sql
SQL
1 vote148 views1 answer
Ms sql - add one hour to time
SQL
0 vote199 views1 answer
Oracle last connexion
SQL
8 votes202 views2 answers
Between operator
SQL
0 vote201 views1 answer
Value of sold product using having and group by in sql
SQL