How to delete or truncate all the records form database with reset the identity column in SQL Server

Hi rani,

Refer the below query.

SQL

USE [DataBaseName]
-- disable all constraints
EXEC sp_msforeachtable 'ALTER TABLE ? NOCHECK CONSTRAINT all'
-- delete data in all tables
EXEC sp_MSForEachTable 'DELETE FROM ?'
-- enable all constraints
exec sp_msforeachtable 'ALTER TABLE ? WITH CHECK CHECK CONSTRAINT all'
-- reset identity
EXEC sp_MSforeachtable 'DBCC CHECKIDENT ( ''?'', RESEED, 0)'

Also refer the below link for other options.

http://stackoverflow.com/questions/155246/how-do-you-truncate-all-tables-in-a-database-using-tsql