/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 vote378 views1 answer
Delete dublicate rows sql
SQL
1 vote372 views1 answer
T-sql disable system versioning
SQL
0 vote323 views1 answer
Get last updated row sql server
SQL
8 votes340 views1 answer
Script to add datafile to tablespace
SQL
0 vote318 views1 answer
Mysql illegal mix of collations for operation 'concat'
SQL
0 vote319 views1 answer
Mysql default uuid
SQL
0 vote335 views1 answer
Désinstaller postgresql linux
SQL
0 vote335 views1 answer
. (provider: SQL Network Interfaces, error: 26 - Error Locating Server/Instance Specified) (.Net SqlClient Data Provider)
SQL
2 votes315 views6 answers
In in sql
SQL
24 votes334 views6 answers
Rename a column in sql server
SQL