Answer Detail: RE: Explain the difference between the “truncate” and ...

GeekInterview.com > Interview Questions > Data Warehousing > Abinitio

Print |

Question: Explain the difference between the “truncate” and "delete" commands.

January 01, 2006 06:14:38	#3
karthik	Member Since: Visitor Total Comments: N/A
RE: Explain the difference between the “truncate” and ...
When you use truncate all the space alloted for the records along with records gets deleted and if you use delete only the records are deleted and the space allocated for the records remains unaltered.