Show Navigation | Hide Navigation
You are here:
Geoprocessing tool reference > Data Management toolbox > Layers and Table Views toolset > Tools

Make Table View (Data Management)

Release 9.2
Last modified November 29, 2010
E-mail This Topic Printable Version Give Us Feedback

Print all topics in : "Tools"


Related Topics

Creates a table view from an input table or feature class. Table views are tables stored in memory and are the same as the table view created when a table is added to ArcMap.

Learn more about working with table views


Usage tips

Command line syntax
An overview of the Command Line window
MakeTableView_management <in_table> <out_view> {where_clause} {workspace} {field_info}

Parameter Explanation Data Type
<in_table>

The input table or feature class.

Table View | Raster Layer
<out_view>

The name of the in-memory table view to be created.

Table View | Raster Layer
{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, shapefiles, coverages, 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
{workspace}

The workspace used to validate the field names. The field names in the table view will be formated according to the workspace type.

Workspace
{field_info}

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

Field Info
Data types for geoprocessing tool parameters


Command line example

MakeTableView_management D:\Workspace\NFLD.mdb\roads 'TCH' "[ROAD_CLASS] = 'TCH'" "LEVEL ROAD_CODE VISIBLE, NAME NAME HIDDEN"

Scripting syntax
About getting started with writing geoprocessing scripts
MakeTableView_management (in_table, out_view, where_clause, workspace, field_info)

Parameter Explanation Data Type
in_table (Required)

The input table or feature class.

Table View | Raster Layer
out_view (Required)

The name of the in-memory table view to be created.

Table View | Raster Layer
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, 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
workspace (Optional)

The workspace used to validate the field names. The field names in the table view will be formated according to the workspace type.

Workspace
field_info (Optional)

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

Field Info

Data types for geoprocessing tool parameters


Script example

import arcgisscripting
gp = arcgisscripting.create()

gp.workspace = "d:/workspace/NFLD.mdb"
gp.maketableview "nf_roads", "TCH", "[ROAD_CLASS] = 'TCH'", "LEVEL ROAD_CODE VISIBLE, NAME NAME HIDDEN"

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