nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

How to find a field in all FC inside a FGDB

Good afternoon,

Is there a way to identity all the feature classes that use a specific field in a FGDB?

Find more posts tagged with

Database Access

Databases

Data Design

Accepted answers

Using the Generate Schema Report tool to create an xlsx schema report gives you a table that lets you answer this question without needing to write any Python:

All comments

AlfredBaldenweck

You have to go through them individually.

Something like (untested)

gdb = r"your path to gbd"
arcpy.env.workspace = gdb
fieldName = "Martians_Present"
usesFields = []

for fc in arcpy.ListFeatureClasses():
    fields = [f.name for f in arcpy.ListFields(fc)]
    if fieldName in fields:
        usesFields.append(fc)

print(usesFields)

Using the Generate Schema Report tool to create an xlsx schema report gives you a table that lets you answer this question without needing to write any Python:

Join the Conversation

Signed in members can post, follow updates, and more. New here? Register a free account.

Quick Links

Community Help
Find useful guides, FAQs, and documents to help you navigate and make the most of Esri Community.