Home » Other » General » Re: Deleting Duplicate Records
Re: Deleting Duplicate Records [message #101980] Sat, 22 December 2001 19:41
ashutosh
Messages: 6
Registered: December 2001
Junior Member
1. get all the distinct records in temporary table
2. truncate orignal table
3. copy data back into orignal table .
NOTE : Always Truncate the orignal table and do not use DELETE statement for this purpose b'se DELETE fires TRIGERRS (if attached ) and truncate dosent.

----------------------------------------------------------------------

Report message to a moderator

Previous Topic: i only know oracle and developer
Next Topic: Re: dumps on CCNA,
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Fri Mar 13 14:51:02 CDT 2026
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.