Table Select (Analysis Tools)

Summary

Selects table records matching a Structured Query Language (SQL) expression and writes them to an output table.

Usage

The input can be a dBASE, or geodatabase table, a feature class, table view, or VPF dataset.
The Expression parameter value can be created with the Query Builder or simply typed in. For details on the expression syntax, see SQL reference for query expressions used in ArcGIS or Introduction to query expressions.
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.
To create a table from the table view's selected set of records, use the Copy Rows tool.

Label	Explanation	Data type
Input Table	The table containing records matching the specified expression that will be written to the output table.	Table View; Raster Layer
Output Table	The output table containing records from the input table that match the specified expression.	Table
Expression (Optional)	An SQL expression used to select a subset of records. For more information on SQL syntax, see Introduction to query expressions.	SQL Expression

arcpy.analysis.TableSelect(in_table, out_table, {where_clause})

Name	Explanation	Data type
in_table	The table containing records matching the specified expression that 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 Introduction to query expressions.	SQL Expression

Code sample

TableSelect example (Python window)

The following Python window script demonstrates how to use the TableSelect function in immediate mode.

import arcpy
arcpy.env.workspace = "C:/data"
arcpy.analysis.TableSelect("majorrds.shp", "C:/output/majorrdsCl4.shp", '"CLASS" = \'4\'')

TableSelect example 2 (stand-alone script)

The following Python script demonstrates how to use the TableSelect function in a stand-alone script.

# Name: TableSelect_Example2.py
# Description: Select class4 roads from the major roads gnatcatcher habitat study area

# Import system modules
import arcpy

# Set workspace
arcpy.env.workspace = "C:/data"

# Set local variables
in_features = "majorrds.shp"
out_feature_class = "C:/output/majorrdsCl4.shp"
where_clause = '"CLASS" = \'4\''

# Run TableSelect
arcpy.analysis.TableSelect(in_features, out_feature_class, where_clause)

Environments

Output CONFIG Keyword, Current Workspace, Scratch Workspace

Licensing information