How to find a field in all FC inside a FGDB

[SanchezNuñez]

Good afternoon,

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

[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)

[RobertKrisher · Accepted solution]

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: