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 :: rename column postgres
Sql :: configure: error: Cannot find libpq-fe.h. Please specify correct PostgreSQL installation path
Sql :: group_concat length limit
Sql :: mssql current date
Sql :: mysql backup
Sql :: mysql show processlist full query
Sql :: mysql concatenate two columns into one
Sql :: mysql timestamp in laravel migration
Sql :: revokeprivileges mysql
Sql :: postgresql search all tables for column name
Sql :: insert column with default value in sql
Sql :: mysql dump database command line linux
Sql :: mysql take number in string
Sql :: ORA-01950
Sql :: install mysqldump ubuntu
Sql :: sql server find all foreign keys that reference a column
Sql :: grab all records from one table to another oracle sql
Sql :: oracle next run dates
Sql :: ms sql how to see active job current run time
Sql :: generate random data postgresql
Sql :: mysql date - 1 day
Sql :: mysql where in array
Sql :: nvl postgres
Sql :: check constraint to check if date greater than todays date
Sql :: duplicate column values sql
Sql :: psql show with user is logged in
Sql :: tsql rename table
Sql :: sql sort column by date
Sql :: truncate table
Sql :: sql server check table exists