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 :: get primary key of table
Sql :: running percentage of total postgres
Sql :: postgres statistics
Sql :: c# sql select
Sql :: copy table in mysql with data
Sql :: Query the list of CITY names starting with vowels (i.e., a, e, i, o, or u) from STATION. Your result cannot contain duplicates.
Sql :: convert sql to relational algebra
Sql :: mysql database is not starting in xampp
Sql :: oracle convert int to date
Sql :: mysql subdate
Sql :: how to find lowest in sql
Sql :: login to mysql database
Sql :: DROP TABLes regardless of constraints
Sql :: rename table column postgresql
Sql :: to date oracle
Sql :: create stored procedure
Sql :: ms sql print from new line
Sql :: string to sql timestamp
Sql :: create index mysql
Sql :: mysql store ip address
Sql :: postgre sql create table
Sql :: python postgresQL select table
Sql :: phone no data type in sql server
Sql :: sql all columns
Sql :: codigo crear tablas sql server
Sql :: full sql mode
Sql :: rename table name
Sql :: brew start postgres
Sql :: sql if empty then
Sql :: postgre alter table foreign key