Results 1 to 3 of 3
  1. #1
    Join Date
    Oct 2003
    Location
    Switzerland
    Posts
    4

    Unanswered: undelete deleted recrods from table

    hello forum

    Is there way to undelete deleted records from a table? - For security reasons I need to delete records without removing them out of the database.

    In other words: target is to design a procedure to delete records only logical.

    I had the idea to use a field, saying record is deleted or not.
    This field would control if data is hidden (logical deleted) or not. To undelete a record, only this field would change its state.

    But it becomes difficult if you have many FK to logical deleted data.

    Is there a better or easier way to do this?


    Thanks for you help !!

  2. #2
    Join Date
    Nov 2002
    Location
    Jersey
    Posts
    10,322
    How about moving them to a logically deleted table and then create a view?
    Brett
    8-)

    It's a Great Day for America everybody!

    dbforums Yak CorralRadio 'Rita
    dbForums Member List
    I'm Good Once as I ever was

    The physical order of data in a database has no meaning.

  3. #3
    Join Date
    Jul 2003
    Location
    London
    Posts
    26
    The way we normally do this is to have a delete trigger on the table and insert the deleted record into another identical table.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •