Table Select (Analysis)

License Level:BasicStandardAdvanced

Summary

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

Usage

Syntax

TableSelect_analysis (in_table, out_table, {where_clause})
ParameterExplanationData 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. The syntax for the expression differs slightly depending on the data source. For example, if you're querying file or ArcSDE geodatabases, shapefiles, coverages, or dBASE or INFO tables, enclose field names in double quotes:

"MY_FIELD"

If you're querying personal geodatabases, enclose fields in square brackets:

[MY_FIELD]

In Python, strings are enclosed in matching single or double quotes. To create a string that contains quotes (as is common with a WHERE clause in SQL expressions), you can escape the quotes (using a backslash) or triple quote the string. For example, if the intended WHERE clause is

"CITY_NAME" = 'Chicago'

you could enclose the entire string in double quotes, then escape the interior double quotes like this:

" \"CITY_NAME\" = 'Chicago' "

Or you could enclose the entire string in single quotes, then escape the interior single quotes like this:

' "CITY_NAME" = \'Chicago\' '

Or you could enclose the entire string in triple quotes without escaping:

""" "CITY_NAME" = 'Chicago' """

For more information on SQL syntax and how it differs between data sources, see the help topic SQL reference for query expressions used in ArcGIS.

SQL Expression

Code Sample

Table Select Example (Python Window)

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\'')
Table Select Example 2 (Stand-alone Python Script)

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)

Environments

Related Topics

Licensing Information

ArcGIS for Desktop Basic: Yes
ArcGIS for Desktop Standard: Yes
ArcGIS for Desktop Advanced: Yes
5/6/2013