Page 1 of 1

Delete old data or junk data in the tables

PostPosted: Mon May 10, 2010 10:11 pm
by rajkusar
Hi All,
We need to delete all the rows in a table that were inserted or updated in the table before a specified date or time-stamp. The table does not contain any column that reflects the insert or update time-stamp. Please let me know if we can do the same by using any method. Any help would be highly appreciated.

Regards,
Rajesh

Re: Delete old data or junk data in the tables

PostPosted: Mon May 10, 2010 10:38 pm
by enrico-sorichetti
NO!

to delete something with a query You must define the logic behind

also You need to define junk data

Re: Delete old data or junk data in the tables

PostPosted: Mon May 10, 2010 11:50 pm
by dick scherrer
Hello,

If you want to delete based on date, there needs to be a date column. . .

Do all of the problem rows contain "junk" in one or more columns?

Just what is junk?

It may be more productive to unload the table, work with the unloaded data, and reload only what is worth keeping. . .