bo_clear_data.sql 364 B

1234567891011
  1. EXEC sp_msforeachtable "ALTER TABLE ? NOCHECK CONSTRAINT all"
  2. GO
  3. EXEC sp_msforeachtable "DELETE FROM ?"
  4. GO
  5. EXEC sp_msforeachtable "ALTER TABLE ? WITH CHECK CHECK CONSTRAINT all"
  6. GO
  7. EXEC sp_msforeachtable "DBCC CHECKIDENT('?', RESEED, 1)", @whereand="and Schema_Id=Schema_id('dbo') and not o.Name in ('UserWorkspace','MetadocumentTag','MetadocumentBilling')"
  8. GO