Sql

	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 :: mysql current running queries
Sql :: cannot truncate a table referenced in a foreign key constraint
Sql :: identity insert on sql server
Sql :: installing mysql
Sql :: Port 5432 is already in use Usually this means that there is already a PostgreSQL server running on your Mac. If you want to run multiple servers simultaneously, use different ports.
Sql :: postgres get all tables in schema
Sql :: freemysqlhosting keeps deleting tables
Sql :: doublon sql
Sql :: copy table oracle
Sql :: restart the psql server windows
Sql :: select duplicates in sql
Sql :: postgresql add enum value
Sql :: copy table sql server
Sql :: how to list columns for particular tables in postgresql
Sql :: postgres alter user password
Sql :: mysql update field from one table to another
Sql :: get schema of table sql
Sql :: how to see which columns are indexxed mysql
Sql :: wordpress sql find and replace
Sql :: mysql select last 15 minutes
Sql :: sql alter table add column if exists
Sql :: mariadb get column names from table
Sql :: top 10 rows in mysql
Sql :: postgres delete database
Sql :: sqlserver add column to table
Sql :: check all sequences oracle sql
Sql :: oracle alter sequence restart start with
Sql :: oracle detect invalid password
Sql :: get month of date sql
Sql :: mysql id of inserted row