Show Navigation | Hide Navigation
You are here:
Geoprocessing tool reference > Analysis toolbox > Extract toolset > Tools

Table Select (Analysis)

Release 9.2
Last modified January 13, 2009
E-mail This Topic Printable Version Give Us Feedback

Print all topics in : "Tools"


Related Topics

Extracts selected table records or features from an input table or table view and stores them in a new output table.


Usage tips

Command line syntax
An overview of the Command Line window
TableSelect_analysis <in_table> <out_table> {where_clause}

Parameter Explanation Data Type
<in_table>

The input table can be an INFO table, a dBASE table, a geodatabase table, a feature class, or a table view.

Table View | Raster Layer
<out_table>

The output table to be created. The output table can be a dBASE table or a geodatabase table.

Table
{where_clause}

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, 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].

For more information on SQL syntax and how it differs between data sources, see SQL Reference.

SQL Expression
Data types for geoprocessing tool parameters


Command line example

tableselect_analysis d:\workspace\wells.shp d:\workspace\wells_Gas.dbf "WELL_TYP" = 'GAS'

Scripting syntax
About getting started with writing geoprocessing scripts
TableSelect_analysis (in_table, out_table, where_clause)

Parameter Explanation Data Type
in_table (Required)

The input table can be an INFO table, a dBASE table, a geodatabase table, a feature class, or a table view.

Table View | Raster Layer
out_table (Required)

The output table to be created. The output table can be a dBASE table or a geodatabase table.

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, 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].

For more information on SQL syntax and how it differs between data sources, see SQL Reference.

SQL Expression

Data types for geoprocessing tool parameters


Script example

import arcgisscripting
gp = arcgisscripting.create()

gp.workspace = "h:/workspace"
gp.tableselect("nfroads.shp", "paved.dbf", '"ROAD_CLASS" = \'PAVED\'')

Please visit the Feedback page to comment or give suggestions on ArcGIS Desktop Help.
Copyright © Environmental Systems Research Institute, Inc.