Delete Rows (Data Management)

AllSource 1.0    |

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.

Usage

  • The Input Rows parameter can be a dBASE table, an enterprise or file geodatabase table or feature class, shapefile, layer, or table view.

  • If this tool is used on feature data, the entire row, including the geometry, will be deleted.

  • If a layer or table view is input, and the layer or table view does not have a selection, all rows will be deleted. If a table is input, all rows will be deleted.

    Note:

    Deleting all rows from a table with a large number of rows can be slow. If your intent is to delete all the rows in the table, you should consider using the Truncate Table tool instead. See the Truncate Table documentation for important cautionary statements on its use.

Parameters

LabelExplanationData Type
Input Rows

The feature class, layer, table, or table view whose rows will be deleted.

Table View

Derived Output

LabelExplanationData Type
Updated Input With Rows Removed

The updated input.

Table View

Environments