Empty a database

Question

Viewing 8 posts - 1 through 7 (of 7 total)

You must be logged in to reply to this topic. Login to reply

Grant Fritchey SSC Guru Points: 398890 More actions · Answer 1

Quick and dirty, completely inelegant and unefficient and you might have to run it two or three times in a row, but it will do the job.

sp_msforeachtable

'delete from ?'

"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt

GigiMi SSC-Addicted Points: 402 More actions · Answer 2

SSC-Addicted

Points: 402

May 18, 2007 at 8:45 am

Thank you so much Grant

Luigi

MohammedU SSCoach Points: 19644 More actions · Answer 3

You may get into issues if your tables are bigger while deleting the data...

sp_msforeachtable 'truncate table ?'

Note: if your table have FK then drop the FKs first and recreate them after truncate...

MohammedU
Microsoft SQL Server MVP

Joel Ewald SSCertifiable Points: 6120 More actions · Answer 4

if you have tables with large number of records it may be a good idea to just script out all your creates and recreate the db.

Grant Fritchey SSC Guru Points: 398890 More actions · Answer 5

Actually, I haddn't thought of that, but yeah, in most cases this is probably quicker.

"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt

GigiMi SSC-Addicted Points: 402 More actions · Answer 6

SSC-Addicted

Points: 402

May 22, 2007 at 6:04 am

Ok, thanks you all.

Luigi

jezemine SSCrazy Eights Points: 8059 More actions · Answer 7

sounds like what you really want is DROP DATABASE.

---------------------------------------
elsasoft.org