What's the difference between "Delete Rows" and "Truncate Table" under Data Management Tools?

4813
2
Jump to solution
06-06-2016 04:30 PM
EmilyLee
Occasional Contributor II

Hello:

What's the difference between "Delete Rows" and "Truncate Table" under Data Management Tools?  When do I use one over the other?

Thank you!

0 Kudos
1 Solution

Accepted Solutions
AsrujitSengupta
Regular Contributor III

DeleteFeatures_management or truncate?

Delete Rows—Help | ArcGIS for Desktop

Truncate Table—Help | ArcGIS for Desktop

Truncate Tool cannot be used with Versioned data. It does not allow you to select a subset of the data for deletion. It runs much faster because of this as it deletes the records using Truncate procedure in the databases.

Delete Rows or Delete Records, also deletes the records....but 1 by 1....not at one go.

Read through the links and let us know if you still have doubts or need any more clarifications.

View solution in original post

2 Replies
AsrujitSengupta
Regular Contributor III

DeleteFeatures_management or truncate?

Delete Rows—Help | ArcGIS for Desktop

Truncate Table—Help | ArcGIS for Desktop

Truncate Tool cannot be used with Versioned data. It does not allow you to select a subset of the data for deletion. It runs much faster because of this as it deletes the records using Truncate procedure in the databases.

Delete Rows or Delete Records, also deletes the records....but 1 by 1....not at one go.

Read through the links and let us know if you still have doubts or need any more clarifications.

EmilyLee
Occasional Contributor II

This is perfect! Thank you, Asrujit!

0 Kudos