Answers for "psql reset id sequence"

SQL
5

tsql reseed identity

USE AdventureWorks2012;  
GO  
DBCC CHECKIDENT ('Person.AddressType', RESEED, 10);  
GO
Posted by: Guest on March-11-2020
1

reset identity column in sql server

DBCC CHECKIDENT ('YourTableName', RESEED, 1)
Posted by: Guest on December-15-2020
1

reset id sequence postgres

alter sequence <tableName>_id_seq restart with 1;
For an instance, we have a table named "groups" and we need to reset the id sequence with 1. 
alter sequence groups_id_seq restart with 1;
Posted by: Guest on July-06-2020

Code answers related to "SQL"

Browse Popular Code Answers by Language