bo/@Database/bo_clear_data.sql

USE [BO]
GO

EXEC sp_msforeachtable "ALTER TABLE ? NOCHECK CONSTRAINT all"
GO

EXEC sp_msforeachtable "DELETE FROM ?"
GO

EXEC sp_msforeachtable "ALTER TABLE ? WITH CHECK CHECK CONSTRAINT all"
GO

EXEC sp_msforeachtable "DBCC CHECKIDENT('?', RESEED, 1)"
GO