Deleteing All Rows From Database

  • Comments posted to this topic are about the item Deleteing All Rows From Database

  • That's a cool quick and dirty way to do this. However there's always the otion of scripting everything, then creating a new blank db. Both solutions work, it only depends on how urgently you need to wipe out that baby.

  • Be good to see some mods to the script:

    1) Check if the table can be truncated (no foreign keys etc) and use Truncate Table instead of delete if this is the case. [Delete logging may take a significant amount of time on large tables]

    2) Check the recovery model of the database first and alter it to simple if not already in this state

  • First, really appreciate of this script code.

    Abhijit, am new to sql server and i know sql in application oriented only not in scripting side.

    Could you please explain me how it works and where to run this script.

    many thanks

Viewing 4 posts - 1 through 3 (of 3 total)

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