Need to add a Tool to my ModelBuider to Delete only the content from an Enterprise (SDE) Geodatabase (containing features classes, tables, relationship classes).

Tool "Delete" (from Toolbox "Data Management") deletes the Geodatabase and only want to delete its content.

Any help?

  • Look at the Truncate Table tool under Table in Data Management.
    – Vince
    Aug 28, 2015 at 14:48
  • I am not sure if this will accomplish the goal, I believe the truncate tool has to be run on individual tables, and will not truncate all objects in a work space.
    – Michael B
    Aug 28, 2015 at 15:40
  • Truncate is the most efficient way to remove features from an enterpise table (orders of magnitude faster than Delete). It would be need to be run on each object, in the appropriate order to avoid referential constraints.
    – Vince
    Aug 28, 2015 at 17:02
  • The question is not about truncating tables to preserve table structure, it is about deleting database objects entirely.
    – Michael B
    Aug 29, 2015 at 16:01

2 Answers 2


I would suggest you create a series of models using iterators. You can create a model for each type and nest the models as sub models in order to include all of them into a single model. You would have to do this because a model can have only one iterator. So each model will iterate through the data object then deltete. Use preconditions to control the flow. That should work perfectly for what you are trying to acomplish.

And example of what I mean below: enter image description here


IF you R-click the "Truncate Table", you have an option to do batch. This will allow you to add as many tables that you would need to perform this tool for.

  • While this would work to remove all records from each feature class or table, the question is asking how to remove the actual feature classes and tables, not just the records.
    – Midavalo
    Oct 7, 2016 at 19:54

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.