ArcGIS for Desktop

  • Documentation
  • Pricing
  • Support

  • My Profile
  • Help
  • Sign Out
ArcGIS for Desktop

ArcGIS Online

The mapping platform for your organization

ArcGIS for Desktop

A complete professional GIS

ArcGIS for Server

GIS in your enterprise

ArcGIS for Developers

Tools to build location-aware apps

ArcGIS Solutions

Free template maps and apps for your industry

ArcGIS Marketplace

Get apps and data for your organization

  • Documentation
  • Pricing
  • Support
Esri
  • Sign In
user
  • My Profile
  • Sign Out

Help

  • Home
  • Get Started
  • Map
  • Analyze
  • Manage Data
  • Tools
  • More...

Table Select

  • Summary
  • Usage
  • Syntax
  • Code Sample
  • Environments
  • Licensing Information

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

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. For more information on SQL syntax see the help topic .

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

  • Output CONFIG Keyword

Licensing Information

  • ArcGIS for Desktop Basic: Yes
  • ArcGIS for Desktop Standard: Yes
  • ArcGIS for Desktop Advanced: Yes

Related Topics

  • An overview of the Extract toolset
Feedback on this topic?

ArcGIS for Desktop

  • Home
  • Documentation
  • Pricing
  • Support

ArcGIS Platform

  • ArcGIS Online
  • ArcGIS for Desktop
  • ArcGIS for Server
  • ArcGIS for Developers
  • ArcGIS Solutions
  • ArcGIS Marketplace

About Esri

  • About Us
  • Careers
  • Insiders Blog
  • User Conference
  • Developer Summit
Esri
© Copyright 2016 Environmental Systems Research Institute, Inc. | Privacy | Legal