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

0 vote191 views1 answer
Mysql find the row ites of the hoghest value at on column
SQL
0 vote192 views1 answer
Psql get table data types
SQL
15 votes206 views4 answers
Mysql export database command line
SQL
0 vote201 views1 answer
Unique element in sql
SQL
3 votes198 views2 answers
Mysql create database
SQL
2 votes195 views1 answer
Sql update alias
SQL
1 vote199 views1 answer
Copy postgres table from one schema into another
SQL
5 votes192 views1 answer
Oracle scan source ddl
SQL
0 vote187 views1 answer
Drop domain postgresql
SQL
0 vote193 views2 answers
Reduce size of SQL server log file truncate - Source :NAYCode.com
SQL