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

0 vote328 views1 answer
Amount of entries in a table psql
SQL
0 vote291 views1 answer
Modificar tipo de dato sql server
SQL
0 vote319 views1 answer
Oarcale list objects
SQL
0 vote306 views1 answer
T-SQL Create Trigger
SQL
0 vote304 views1 answer
Postgresql combine values in one field
SQL
1 vote322 views1 answer
Dropping a constraint in ms sql
SQL
0 vote277 views1 answer
INSERT INTO table using OpenQuery
SQL
0 vote240 views1 answer
Mysql collation for all languages
SQL
0 vote309 views1 answer
Check the size of the tables here ordered from the biggest size
SQL
0 vote355 views1 answer
Error Code: 1267. Illegal mix of collations (latin1_general_ci,IMPLICIT) and (latin1_swedish_ci,IMPLICIT) for operation '=' 0.000 sec
SQL