/*---重置自動標識列---*/
DBCC CHECKIDENT ('wf_workflow', RESEED, 0)
DBCC CHECKIDENT ('wf_app_roles', RESEED, 0)
DBCC CHECKIDENT ('wf_transition', RESEED, 0)
DBCC CHECKIDENT ('wf_transition_user', RESEED, 0)
DBCC CHECKIDENT ('wf_place', RESEED, 0)
DBCC CHECKIDENT ('wf_arc', RESEED, 0)
/*---清空數據庫---*/
EXEC sp_MSForEachTable 'ALTER TABLE ? NOCHECK CONSTRAINT ALL'
EXEC sp_MSForEachTable 'ALTER TABLE ? DISABLE TRIGGER ALL'
EXEC sp_MSForEachTable 'DELETE FROM ?'
EXEC sp_MSForEachTable 'ALTER TABLE ? CHECK CONSTRAINT ALL'
EXEC sp_MSForEachTable 'ALTER TABLE ? ENABLE TRIGGER ALL'