Main menu

Pages

Analyze, Copy Rows, Create and Unregistered Table, Delete Rows, Get Count, Pivot Table and Truncate Table

Analyze, Copy Rows, Create and Unregistered Table, Delete Rows, Get Count, Pivot Table and Truncate Table Tools

Analyze

How to Analyze Tool in Arc Toolbox ArcMap ArcGIS??

Analyze Tool
Analyze Tool

Path to access the tool

:

Analyze Tool, Table Toolset, Data Management Tools Toolbox

 

Analyze

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

1.    Input Dataset

The table or feature class to be analyzed.

2.    Components to Analyze

The component type to be analyzed.

  1. BUSINESS—Updates business rules statistics.
  2. FEATURE—Updates feature statistics.
  3. RASTER—Updates statistics on raster tables.
  4. ADDS—Updates statistics on added datasets.
  5. DELETES—Updates statistics on deleted datasets.

Copy Rows

How to Copy Rows Tool in Arc Toolbox ArcMap ArcGIS??

Copy Rows Tool
Copy Rows

Path to access the tool

:

Copy Rows Tool, Table Toolset, Data Management Tools Toolbox

 

Copy Rows

Copies the rows of a table, table view, feature class, feature layer, or raster with attribute table to a new geodatabase, .csv, .txt, or .dbf table. If the table or feature layer has a selection, only the selected rows are copied to the output table.

1.    Input Rows

The input rows to be copied to a new table.

2.    Output Table

The table that will be created and to which rows from the input will be copied.

If the output table is in a folder, include an extension such as .csv, .txt, or .dbf to make the table the specified format. If the output table is in a geodatabase, do not specify an extension.

3.    Configuration Keyword (optional)

Specifies the default storage parameters for an enterprise geodatabase.

Create Table

How to Create Table Tool in Arc Toolbox ArcMap ArcGIS??

Create Table Tool
Create Table

Path to access the tool

:

Create Table Tool, Table Toolset, Data Management Tools Toolbox

 

Create Table

Creates a geodatabase table, INFO, or dBASE table.

1.    Table Location

The workspace in which the output table will be created.

2.    Table Name

The name of the table to be created.

3.    Template Table Name (optional)

A table whose attribute schema is used to define the output table. Fields in the template tables will be added to the output table.

4.    Configuration Keyword (optional)

The configuration keyword that determines the storage parameters of the table in an enterprise geodatabase.

Create Unregistered Table

How to Create Unregistered Table Tool in Arc Toolbox ArcMap ArcGIS??

Create Unregistered Table Tool
Create Unregistered Table

Path to access the tool

:

Create Unregistered Table Tool, Table Toolset, Data Management Tools Toolbox

 

Create Unregistered Table

Creates an empty table in a database or enterprise geodatabase. The table is not registered with the geodatabase.

1.    Table Location

The enterprise geodatabase or database in which the output table will be created.

2.    Table Name

The name of the table to be created.

3.    Template Table Name (optional)

A table or list of tables whose fields and attribute schema are used to define the fields in the output table.

4.    Configuration Keyword (optional)

Determines the storage parameters of the table in an enterprise geodatabase.

Delete Rows

How to Delete Rows Tool in Arc Toolbox ArcMap ArcGIS??

Delete Rows Tool
Delete Rows

Path to access the tool

:

Delete Rows Tool, Table Toolset, Data Management Tools Toolbox

 

Delete Rows

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

If the input rows are from a feature class or table, all rows will be deleted. If the input rows are from a layer or table view with no selection, all rows will be deleted.

1.    Input Rows

The feature class, layer, table, or table view whose rows will be deleted.

Get Count

How to Get Count Tool in Arc Toolbox ArcMap ArcGIS??

Get Count Tool
Get Count

Path to access the tool

:

Get Count Tool, Table Toolset, Data Management Tools Toolbox

 

Get Count

Returns the total number of rows for a table.

1.    Input Rows

The input table view or raster layer. If a selection is defined on the input, the count of the selected rows is returned.

Pivot Table

How to Pivot Table Tool in Arc Toolbox ArcMap ArcGIS??

Pivot Table Tool
Pivot Table

Path to access the tool

:

Pivot Table Tool, Table Toolset, Data Management Tools Toolbox

 

Pivot Table

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

1.    Input Table

The table whose records will be pivoted.

2.    Input Field(s)

The fields that define records to be included in the output table.

The Add Field button—used only in ModelBuilder—loads expected field(s) from the previous process into the Input Field(s) list.

3.    Pivot Field

The field whose record values are used to generate the field names in the output table.

4.    Value Field

The field whose values populate the pivoted fields in the output table.

5.    Output Table

The table to be created.

Truncate Table

How to Truncate Table Tool in Arc Toolbox ArcMap ArcGIS??

Truncate Table Tool
Truncate Table

Path to access the tool

:

Truncate Table Tool, Table Toolset, Data Management Tools Toolbox

 

Truncate Table

Removes all rows from a database table or feature class using truncate procedures in the database.

1. Input Table

Input database table or feature class that will be truncated.

Comments

table of contents title