Table Select (Analysis)
Summary
Selects table records matching a Structured Query Language (SQL) expression and writes them to an output table.
Usage
-
The input can be an INFO, dBASE, or geodatabase table, a feature class, table view, or VPF dataset.
-
The Expression parameter can be created with the Query Builder or simply typed in. For details on the expression syntax see Building an SQL Expression or SQL Reference.
-
If a table view is used for Input Table and no expression is entered, only the selected records are written to the output table. If a table view is used for input table and an expression is entered, the expression is only executed against the selected records, and the expression-based subset of the selected set is written to the output table.
If you want to create a table from the table view's selected set of records, use the Copy Rows (management) tool.
Syntax
| Parameter | Explanation | Data Type |
in_table |
The table whose records matching the specified expression will be written to the output table. | Table View; Raster Layer |
out_table |
The output table containing records from the input table that match the specified expression. | Table |
where_clause (Optional) |
An SQL expression used to select a subset of records. For more information on SQL syntax see the help topic SQL reference for query expressions used in ArcGIS. | SQL Expression |
Code Sample
The following Python Window script demonstrates how to use the Table Select function in immediate mode.
import arcpy
from arcpy import env
env.workspace = "C:/data"
arcpy.TableSelect_analysis("majorrds.shp", "C:/output/majorrdsCl4.shp", '"CLASS" = \'4\'')
The following Python script demonstrates how to use the Table Select function in a stand-alone script.
# Name: TableSelect_Example2.py
# Description: Selct class4 roads from the major roads gnatcatcher habitat study area
# Author: ESRI
# Import system modules
import arcpy
from arcpy import env
# Set workspace
env.workspace = "C:/data"
# Set local variables
in_features = "majorrds.shp"
out_feature_class = "C:/output/majorrdsCl4.shp"
where_clause = '"CLASS" = \'4\''
# Execute TableSelect
arcpy.TableSelect_analysis(in_features, out_feature_class, where_clause)