/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 vote145 views1 answer
Sql server check whether column has same equal values
SQL
0 vote152 views1 answer
How to check replication lag in mySQL
SQL
0 vote152 views2 answers
Postgres another version
SQL
0 vote152 views1 answer
Mysql query to add hours to column in table
SQL
0 vote161 views1 answer
Casterar postgres
SQL
0 vote165 views1 answer
Sql server roles and users
SQL
0 vote173 views2 answers
Drop tables from local table database postgres
SQL
0 vote158 views1 answer
Changing name of column and datatype in sql
SQL
4 votes166 views1 answer
For loop postgresql
SQL
2 votes171 views1 answer
Install postgresql centos 5
SQL