/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

4 votes292 views2 answers
Oracle set date format
SQL
0 vote360 views1 answer
Mysql relationships between tables
SQL
0 vote341 views1 answer
Updating database in sql
SQL
0 vote307 views1 answer
Query to get all primary keys and foreign key
SQL
0 vote303 views1 answer
Mysql date only no time
SQL
0 vote320 views1 answer
Update All tables COLLATE DATABASE_DEFAULT
SQL
1 vote312 views1 answer
Increase existing date in sql oracle
SQL
0 vote329 views1 answer
Createdb with postgresql on ubuntu
SQL
0 vote318 views1 answer
Whenever i'm passing data from datatable to sql table for large number in table it is storing with e+
SQL
10 votes341 views4 answers
SELECT FROM WHERE
SQL