How to Purge tables ?? [message #221767] |
Wed, 28 February 2007 06:10 |
deepakc
Messages: 10 Registered: February 2007 Location: India
|
Junior Member |
|
|
I want to purge the database, that is except last three months' records i want to delete all others.
I want to know the steps that are to be follwed to do a standard purging., Like backing up the data that are going to be purged, and then deleting the old records.
Is time constraint a must for all tables to be purged, or is there any other way to find the time of the creation of a particular record in a table???
Where can i get these details., ??
Thank u.,
Deepak.C
|
|
|
Re: How to Purge tables ?? [message #221780 is a reply to message #221767] |
Wed, 28 February 2007 06:46 |
JRowbottom
Messages: 5933 Registered: June 2006 Location: Sunny North Yorkshire, ho...
|
Senior Member |
|
|
Unless you've got auditing turned on, then the only way you'll find when a record was created is if you've recorded it on that row.
|
|
|
|
|