/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

3 votes164 views3 answers
Sql last week
SQL
7 votes160 views3 answers
Sql get last inserted row
SQL
6 votes173 views2 answers
Where clause in sql
SQL
0 vote127 views1 answer
Psql not found windows
SQL
0 vote197 views1 answer
Error code 1451 sql
SQL
0 vote166 views1 answer
Sql count null values in all columns
SQL
0 vote165 views1 answer
Access denied for user 'root'@'localhost' workbench ubuntu
SQL
0 vote176 views1 answer
Sql output select
SQL
12 votes162 views4 answers
Mysql ifnull
SQL
123 votes1.1K views5 answers
Sql where contains
SQL