/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 vote195 views1 answer
Sql select upcoming birthdays
SQL
0 vote204 views1 answer
How to remove default in mysql
SQL
0 vote201 views2 answers
FIND OUT THE NAME HIGHEST SALARY SQL
SQL
1 vote194 views1 answer
Backup mysql data only
SQL
9 votes218 views6 answers
Oracle substring
SQL
1 vote186 views1 answer
How to use a trigger to validate input data
SQL
3 votes251 views1 answer
Sql select second max
SQL
0 vote247 views2 answers
How to type a blank discord messgae
SQL
1 vote221 views4 answers
How to check table in postgresql from terminal
SQL
8 votes216 views1 answer
Declare table variable sql server
SQL