MS SQL: Alle Tabellen leeren

Ich möchte das nicht jedes mal googlen:

-- disable referential integrity check:
EXEC sp_MSForEachTable 'ALTER TABLE ? NOCHECK CONSTRAINT ALL'
GO

EXEC sp_MSForEachTable 'DELETE FROM ?'
GO

-- re-enable referential integrity check:
EXEC sp_MSForEachTable 'ALTER TABLE ? WITH CHECK CHECK CONSTRAINT ALL'
GO

-- disable referential integrity check:

EXEC sp_MSForEachTable 'ALTER TABLE ? NOCHECK CONSTRAINT ALL'

EXEC sp_MSForEachTable 'DELETE FROM ?'

-- re-enable referential integrity check:

EXEC sp_MSForEachTable 'ALTER TABLE ? WITH CHECK CHECK CONSTRAINT ALL'

In dem Zusammenhang: Flyway initOnMigrate in Play Applikationen:

flyway.initOnMigrate=true

1	flyway.initOnMigrate=true

crusy.net

MS SQL: Alle Tabellen leeren

Leave a Reply Cancel reply