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 :: change nls_date_format
Sql :: postgresql stop all connections
Sql :: postgresql reset sequence
Sql :: mysql current running queries
Sql :: mysql get table size
Sql :: Find all triggers in database
Sql :: redshift running queries
Sql :: mysql alter column default
Sql :: mysql find tables with name
Sql :: copy table oracle
Sql :: alter table column change data type to text mysql
Sql :: alter table add comment oracle
Sql :: mysql query to get column names
Sql :: sql drop table if exists
Sql :: how to remove tables from postgresql
Sql :: remove accented characters from string sql
Sql :: postgresql truncate cascade restart identity
Sql :: oracle get table column names
Sql :: postgres delete from where date is greater than specific date
Sql :: change column names mssql
Sql :: primary key reset in SQL database
Sql :: list mysql users
Sql :: how to show all users in mysql
Sql :: how to update date add hours in postgresql
Sql :: oracle check table space
Sql :: how to delay stored procedure execution in sql server
Sql :: add constraint fk
Sql :: sql missing records from another table
Sql :: how to check database size in mysql
Sql :: oracle sql assign unique number to each grouping