Restart identity cascade

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

3 votes327 views4 answers
Show databases in sql server
SQL
0 vote333 views2 answers
Timing sql queries
SQL
14 votes308 views2 answers
Sql cast
SQL
0 vote326 views1 answer
Mysql workbench view
SQL
1 vote320 views1 answer
Oracle split string
SQL
2 votes332 views1 answer
How to find constraints on a table in oracle
SQL
0 vote333 views1 answer
Sql composite key
SQL
0 vote380 views1 answer
Postgresql alter table sequence
SQL
0 vote325 views1 answer
Mysql create pool
SQL
0 vote325 views2 answers
SQL BULK INSERT
SQL