How to truncate file geodatabase tables with Python?

Question

I need to truncate file geodatabase tables (1 or all) with Python. What is the code for that?

Answer 1

As of 10.1, Esri has added Truncate Table (Data Management). It will remove all records from a table, regardless of a table view selection, and does not support versioned tables. It is much faster, though.

Esri's sample code for truncating all tables in a geodatabase:

# Set the workspace.
arcpy.env.workspace = "C:/work/vancouver.gdb"

# Get a list of all the tables.
tableList = arcpy.ListTables()

# Loop through the list and run truncate
for table in tableList:
    arcpy.TruncateTable_management(table)

Answer 2

AFAIK, you can use Delete Rows method in arcpy. from Arcgis Resource Center:

Delete Rows (Data Management)

Summary

Deletes all or the selected subset of rows from the input.

If the input rows are from a feature class or table, all rows will be deleted. If the input rows are from a layer or table view with no selection, all rows will be deleted.

consider this caution:

If run against a layer or table view that does not have a selection, the operation cannot be undone using undo/redo.

Example Code:

import arcpy
from arcpy import env

env.workspace = "C:/data"
arcpy.CopyRows_management("accident.dbf", "C:/output/accident2.dbf")
arcpy.DeleteRows_management("C:/output/accident2.dbf")

i hope it helps you...

Answer 3

import arcpy

from arcpy import env

wrksp = r"workspace"

env.workspace = wrksp


fcs = arcpy.ListFeatureClasses()

for fc in fcs:

    arcpy.MakeTableView_management(fc, "fc_Temp")

    arcpy.DeleteRows_management("fc_Temp")