Restart identity cascade

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

6 votes349 views2 answers
Mysql version check cmd
SQL
1 vote380 views1 answer
Access denied for user 'root'@'localhost' python sql-connect error
SQL
0 vote391 views1 answer
Sqlite get date only
SQL
0 vote333 views1 answer
Http://challenge01.root-me.org:58036/wsasd
SQL
4 votes357 views1 answer
Force drop all tables postgres
SQL
0 vote365 views1 answer
Sqlcmd xml output insert line break after every 2033 characters
SQL
0 vote362 views1 answer
Sql server alter table column nullable
SQL
0 vote340 views1 answer
AddEntityFrameworkSqlite
SQL
0 vote371 views1 answer
Mysql page segment
SQL
2 votes364 views4 answers
Sql query interview questions
SQL