Iterate through SDE to find and export FCs with Attribute Rules with python?

amarcz_cc

Hello all,

I am wondering if you can use python to iterate through an SDE to locate feature classes that have attribute rules, then export them to a folder for safe keeping?

A follow up to this will be to remove all attribute rules from said feature classes for different workflows.

I appreciate any help, I could only find documentation on how to describe the properties within a single FC.

Thank you.

jskinner

@amarcz_cc,

Here's an example on how to iterate through an Enterprise Geodatabase and find which feature classes have attribute rules.

import arcpy

# Geodatabase
gdb = r"C:\data\gis.sde"

# Set workspace
arcpy.env.workspace = gdb

# Iterate through each feature class
for dataset in arcpy.ListDatasets("*"):
    for fc in arcpy.ListFeatureClasses("*", feature_dataset=dataset):
        # Check if feature class has attribute rules
        attRules = arcpy.Describe(fc).attributeRules
        try:
            if attRules[0].name != None:
                print(fc)
                # Export Attribute Rules
        except:
            pass
for fc in arcpy.ListFeatureClasses("*"):
    # Check if feature class has attribute rules
    attRules = arcpy.Describe(fc).attributeRules
    try:
        if attRules[0].name != None:
            print(fc)
            # Export Attribute Rules
    except:
        pass