Post reply

Deletion

  • November 6, 2007 at 5:15 pm

    #183799

    Hi all,

    I have a table in xyz database and there is no column in table like creation_date or modified_date.

    The problem is I want to delete records which has been added in the table before 1st jan 2007.

    The size of table is 85 GB

    Immediate help would be appriciable.

    Regards,

    Austin

  • November 6, 2007 at 6:28 pm

    #748925

    Without some other way of identifying the date, it'd be your guess.

    Is there a date in a table which relates to xyz table? Any historical references at all?

  • November 6, 2007 at 6:51 pm

    #748927

    Thanks for reply,

    There are no columns in the table which show history inf.

    I think the best solution is to create the script for the objects which has been created after 31/12/2006. Then I can restore the database from 31/12/2006 backup and then I can executed the script.

    Regards,

    Austin

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

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