Viewing 2 posts - 1 through 2 (of 2 total)
divyesh.khimasia 4679 (9/4/2015)Cant we use TRUNCATE?
divyesh.khimasia 4679 (9/4/2015)
No we can't. You cannot specify WHERE clause in TRUNCATE, therefore you cannot specify which rows you want to remove - it just removes all...
September 4, 2015 at 2:14 am
#1824566
Depends on scenario, obsolete vs current rows count, you might also create a copy of table copy rows you need to preserve and then switch them by altering names.
September 4, 2015 at 1:31 am
#1824559