/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 vote230 views1 answer
ORACLE PARSE STRING
SQL
2 votes222 views4 answers
Mysql select into new table
SQL
0 vote218 views1 answer
AddEntityFrameworkSqlite
SQL
0 vote231 views1 answer
Login failed for user sql server
SQL
1 vote217 views1 answer
Oracle sql create or replace view
SQL
0 vote366 views1 answer
The differnece between to values in sql
SQL
13 votes234 views1 answer
Select count of distinct values sql
SQL
3 votes225 views1 answer
How to uninstall microsoft sql server
SQL
-1 vote238 views1 answer
Spring boot mysql connection properties
SQL
4 votes216 views3 answers
Create database in mySQL
SQL