ArcGIS Desktop

  • ArcGIS Pro
  • ArcMap

  • My Profile
  • Help
  • Sign Out
ArcGIS Desktop

ArcGIS Online

The mapping platform for your organization

ArcGIS Desktop

A complete professional GIS

ArcGIS Enterprise

GIS in your enterprise

ArcGIS 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
  • Support
Esri
  • Sign In
user
  • My Profile
  • Sign Out

ArcMap

  • Home
  • Get Started
  • Map
  • Analyze
  • Manage Data
  • Tools
  • Extensions

Remove Attribute Index

  • Summary
  • Usage
  • Syntax
  • Code sample
  • Environments
  • Licensing information

Summary

This tool deletes an attribute index from an existing table, feature class, shapefile, coverage, or attributed relationship class.

Attribute indexes are used by ArcGIS to quickly locate records that match an attribute query.

Usage

  • This tool accepts as input coverage feature classes, shapefiles, file or personal and enterprise geodatabase feature classes, and attribute relationship classes.

  • If the Index Name parameter is empty, there are no attribute indexes in the dataset.

  • Only feature classes from a file or personal geodatabase or SDE database support more than one attribute index. Therefore, the index list can contain only one index to delete unless the input table is from a file or personal geodatabase or SDE database.

  • Once an index has been added, it can be deleted and re-added at any point in the lifetime of the feature class or table.

  • The Index Name or Indexed Item parameter's Add Value button is used only in ModelBuilder. In ModelBuilder, where the preceding tool has not been run, or its derived data does not exist, the Index Name or Indexed Item parameter may not be populated with values. The Add Value button allows you to add expected value(s) so you can complete the Remove Attribute Index dialog box and continue to build your model.

Syntax

arcpy.management.RemoveIndex(in_table, index_name)
ParameterExplanationData Type
in_table

The table containing the index or indexes to be deleted. Table can refer to an actual table, a feature class attribute table, or an attributed relationship class.

Mosaic Layer; Raster Catalog Layer; Raster Layer; Table View
index_name
[index_name,...]

The name of the index or indexes to be deleted.

String

Derived Output

NameExplanationData Type
out_table

The updated input table.

Table View; Raster Layer; Mosaic Layer

Code sample

RemoveIndex example 1 (Python window)

The following code demonstrates how to use RemoveIndex tool in immediate mode.

import arcpy
arcpy.env.workspace = "C:/data/input/indices.gdb"
arcpy.RemoveIndex_management("lakes", ["IndexA", "IndexB"])
RemoveIndex example 2 (stand-alone script)

The following stand-alone script demonstrates how to use the RemoveIndex tool.

import arcpy
 
# Set a default workspace
arcpy.env.workspace = "c:/data"
 
# Remove two indexes from the feature class
arcpy.RemoveIndex_management("/county.gdb/lots", ["indexa", "indexb"])

Environments

  • Current Workspace

Licensing information

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

Related topics

  • An overview of the Indexes toolset

ArcGIS Desktop

  • Home
  • Documentation
  • Support

ArcGIS

  • ArcGIS Online
  • ArcGIS Desktop
  • ArcGIS Enterprise
  • ArcGIS
  • ArcGIS Developer
  • ArcGIS Solutions
  • ArcGIS Marketplace

About Esri

  • About Us
  • Careers
  • Esri Blog
  • User Conference
  • Developer Summit
Esri
Tell us what you think.
Copyright © 2021 Esri. | Privacy | Legal