/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

1 vote127 views1 answer
Set statiscis on in ssms
SQL
1 vote109 views1 answer
Drush sql-dump
SQL
8 votes118 views3 answers
Connect python to mysql
SQL
2 votes116 views1 answer
Oracle apex list connected users
SQL
1 vote121 views1 answer
Altering the column name in MySQL to have a default value
SQL
24 votes118 views5 answers
List mysql users
SQL
0 vote77 views1 answer
Mysql collation for all languages
SQL
1 vote118 views1 answer
Sql server locks
SQL
15 votes118 views5 answers
If null mysql
SQL
3 votes151 views2 answers
Brew restart mysql
SQL