Sql

	DBCC CHECKIDENT ('table name', RESEED , 0)

DBCC CHECKIDENT ('YourTableName', RESEED, 1)

/*If you have delete all the rows in a table, and you want to reset the identity column value, use this*/
DBCC CHECKIDENT ('Table_Name',RESEED,0)

DBCC CHECKIDENT ('Table_Name',RESEED,0)

USE <databasename>;  
GO  
DBCC CHECKIDENT ('<tablename>.<columnname>', <value>, <incrementby>);  
GO

PREVIOUS	NEXT

Code Example
Sql :: Can you Join two Tables With Common Column?
Sql :: oracle drop program
Sql :: insert data to postgresql from excel
Sql :: timestamp(0) postgresql
Sql :: connectionString
Sql :: sqlite get columns for table
Sql :: ubuntu install mysql 5.7
Sql :: replace function in sql
Sql :: inserting values in sql
Sql :: advantages of stored procedures sql
Sql :: local pg_sql to heroku pg_sql
Sql :: add role to group postgres
Sql :: import mysql db
Sql :: connect laravel to mysql on mac
Sql :: character count sql
Sql :: oracle sql distinct vs unique
Sql :: sql less than operator
Sql :: postgresql multiple insert with subquery
Sql :: install sql server management studio ubuntu
Sql :: triggers db
Sql :: how to generate er diagram in mysql workbench
Sql :: alter in mysql
Sql :: missing index for constraint error in mysql
Sql :: how to find symmetric pairs in sql
Sql :: sqlalchemy datetime utcnow
Sql :: mysql config address
Sql :: HOW to select specific table data from an mysql databse server:
Sql :: Load SQLite in Jupyter Notebook together with the access to the file
Sql :: trigger value from maltiple table to single table mysql
Sql :: the most common use php method