/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

8 votes158 views2 answers
Sqlsrv default port
SQL
0 vote150 views1 answer
Oracle synonym procedure dblink
SQL
0 vote159 views1 answer
How to input data as id in database sql c#
SQL
0 vote166 views1 answer
Error code 1451 sql
SQL
0 vote162 views1 answer
T sql dynamic top n query
SQL
1 vote150 views1 answer
Load sql into mamp
SQL
2 votes146 views2 answers
HOW TO FIND MEDIAN IN SQL FOR BOTH IDD AND EVEN
SQL
0 vote140 views1 answer
Mysql case when null
SQL
8 votes138 views3 answers
Duplicate entry
SQL
4 votes181 views2 answers
Postgresql float data type
SQL