/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 vote287 views1 answer
Oracle sql copy table without data
SQL
0 vote273 views1 answer
Sql tablo sp
SQL
0 vote280 views1 answer
Sqlalchemy one column of two has to be not null
SQL
0 vote255 views1 answer
How to find database collation in postgres
SQL
1 vote264 views1 answer
Set autoincrement to 0
SQL
11 votes280 views6 answers
ERROR 1819 (HY000): Your password does not satisfy the current policy requirements
SQL
0 vote278 views1 answer
Change filed order in mysql
SQL
0 vote269 views1 answer
How to do a function to return row type from a table in pl/sql
SQL
3 votes216 views2 answers
Mysql sum with condition
SQL
0 vote266 views1 answer
Get all jobs if salary more than 5500 less than 10000 sql
SQL