List all Indexes within a geodatabase

Brian_McLeer — Sun, 12 Dec 2021 08:42:32 GMT

My goal is to list all indexes that are being used on each feature class in an SDE database with ~50 feature classes that reside, with the end product being a list of the feature class and what the name of the index is.

import arcpy

arcpy.env.workspace = r"Database Connections\Server Database Login.sde"

# Get list of indexes and print properties
FCs = arcpy.ListFeatureClasses()
for FC in FCs:
    indexes = arcpy.ListIndexes(FC)
    for index in indexes:
       print FC
       print("Name : {0}".format(index.name))
       print("IsAscending : {0}".format(index.isAscending))
       print("IsUnique : {0}".format(index.isUnique))‍‍‍‍‍‍‍‍‍‍‍‍‍

topic List all Indexes within a geodatabase in Python Snippets Questions

List all Indexes within a geodatabase