Make Table View (Data Management)

This ArcGIS 3.0 documentation has been archived and is no longer updated. Content and links may be outdated. See the latest documentation.

Summary

Creates a table view from an input table or feature class. The table view that is created by the tool is temporary and will not persist after the session ends unless the document is saved.

Usage

  • This tool is commonly used to create a table view with a selected set of attributes or fields.

  • If an SQL expression is used but returns nothing, the output will be empty.

  • Field names defined in the Field Info control will be honored in subsequent tools. However, if this tool is the last tool in a model, the field names will be obtained from the source data on disk. To maintain the field names, the new layer has to be written out to a new data using Copy Rows or Copy Features tools.

  • The field names will be validated by specifying an input workspace. Thus, if the input is a geodatabase feature class, and the output workspace is a folder, the field names may be truncated, since shapefile attributes can only have names of ten characters or less.

  • A subset of fields can be made unavailable in the new layer by using the Field Info control's visible property. The second column in the control provides a checkbox to specify whether a field will be visible or hidden in the new layer. The default is checked. Uncheck the checkbox to hide that field. You cannot use the hidden fields in a workflow if the newly created layer is input to a subsequent process or tool. If the output is saved to disk, only the fields listed as visible will appear in the new data.

  • The split policy option on the Field Info control does not apply to this tool.

Parameters

LabelExplanationData Type
Input Table

The input table or feature class.

Table View;Raster Layer
Table Name

The name of the table view to be created.

Table View ;Raster Layer
Expression
(Optional)

An SQL expression used to select a subset of records.

SQL Expression
Output Workspace
(Optional)

The input workspace used to validate the field names. If the input is a geodatabase table and the output workspace is a dBASE table, the field names may be truncated, since dBASE fields can only have names of ten characters or less.

Workspace
Field Info
(Optional)

Specifies which fields from the input table to make visible in the output table view.

Field Info

Environments

Licensing information

  • Basic: Yes
  • Standard: Yes
  • Advanced: Yes

Related topics