Geoprocessing tool reference > Data Management toolbox > Table toolset > Tools
Delete Rows (Data Management) |
|
|
Release 9.2
Last modified November 29, 2010 |
Print all topics in : "Tools" |
Deletes selected rows from the input rows.
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, only those rows selected in the layer will be deleted.
Usage tips
-
The input rows can be an INFO table, dBASE file, ArcSDE, file or personal geodatabase feature class or table, shapefile, layer, or table view.
-
If Delete Rows is used on feature data, the entire row, including the geometry, will be deleted.
-
Coverages, CAD, and VPF data are invalid input to this tool. Rows cannot be deleted from these data types without destroying the integrity of the data.
-
If there is no selection in the input rows, all rows will be deleted.
-
The following environments affect this tool:configKeyword, extent, scratchWorkspace and workspace.
Command line syntax
An overview of the Command Line window
DeleteRows_management <in_rows>
| Parameter | Explanation | Data Type |
| <in_rows> |
The feature class, layer, table, or table view whose rows will be deleted. |
Table View |
Command line example
deleterows_management c:\temp\consumers.dbf
Scripting syntax
About getting started with writing geoprocessing scripts
DeleteRows_management (in_rows)
| Parameter | Explanation | Data Type |
| in_rows (Required) |
The feature class, layer, table, or table view whose rows will be deleted. |
Table View |
Data types for geoprocessing tool parameters
Script example
import arcgisscripting
gp = arcgisscripting.create()
gp.workspace = "c:/region/sales.mdb"
gp.toolbox = "management"
# Create a table view and select records to be deleted
gp.maketableview("customers", "customer_view")
query = '[STATUS] = "EXPIRED"'
gp.selectlayerbyattribute("customer_view", "NEW_SELECTION", query)
# Delete selected records
gp.deleterows("customer_view")