• You could simply go

    Delete from Mytable

    It doesn't have the same limitations as TRUNCATE TABLE, although you will have to empty the tables in the "right order" (delete the rows from Children table first, then the Parent tables).

    ----------------------------------------------------------------------------------
    Your lack of planning does not constitute an emergency on my part...unless you're my manager...or a director and above...or a really loud-spoken end-user..All right - what was my emergency again?