An overview of the Table toolset

A table contains a collection of rows and columns, where each row, or record, represents a geographic feature—such as a parcel, power pole, highway, or group of lakes—and each column, or field, describes a particular attribute of the geographic feature, such as its square footage, height, length, and area. Tables are typically stored in a database—for example, INFO, Access, Oracle, SQL Server—or simply in files such as dBASE tables. Tables manage the attributes of geographic features.

The Table tools create and evaluate tabular data from a variety of sources. Analyze and Change Privileges work only with ArcSDE geodatabases. The remainder of the tools provide basic and summary operations for tables.

Tool

Description

Analyze

Updates database statistics of business tables, feature tables, and delta tables, along with the statistics of those tables' indexes.

Change Privileges

Establishes or changes user access privileges to the input ArcSDE datasets, stand-alone feature classes, or tables.

Copy Rows

Writes the rows from an input table, table view, feature class, or feature layer to a new table. If a selection is defined on a feature class or feature layer in ArcMap, only the selected rows are copied out.

Create Table

Creates an ArcSDE, file, or personal geodatabase table, or an INFO or dBASE table.

Delete Rows

Deletes all or the selected subset of rows from the input.

Get Count

Returns the total number of rows for a feature class, table, layer, or raster.

Pivot Table

Creates a table from the input table by reducing redundancy in records and flattening one-to-many relationships.

Table toolset tools

Related Topics

5/7/2015