First of all verify the location and name of you sde (connection) file:
On Windows XP or Server 2003, navigate to Documents and Settings > <user_name> > Application Data > ESRI > Desktop<release#> > ArcCatalog.
On Windows Vista, 7, or Server 2008, navigate to Users > <user_name> > AppData > Roaming > ESRI > Desktop<release#> > ArcCatalog.
The file has an extension of .sde.
Example I have one here:
conn = r"C:\Users\xbakker\AppData\Roaming\ESRI\Desktop10.1\ArcCatalog\NameOfMyConnectionFile.sde"
To make use of the ListTables and ListFeatureClasses(), you will have to set your connection file to be the current workspace. You can do this like this:
arcpy.env.workspace = conn
Since featureclasses can reside in datasets you should list the available datasets first;
lst_fds = arcpy.ListDatasets()
lst_fds.append("")
The second line is to append an empty string to the list of feature datasets, since featureclasses may reside outside a dataset. Next go through each dataset in the list and create for each dataset a list of featureclasses:
for fds in lst_fds:
fcs = arcpy.ListFeatureClasses(feature_dataset=fds)
Using this list of featureclasses you can loop through each featureclass in that list and do something with it:
for fc in fcs:
print fc
So the script to, in this case, print the names of all the featureclasses in the enterprise geodatabase would be:
import arcpy
# name and location of your connection file
conn = r"C:\Users\xbakker\AppData\Roaming\ESRI\Desktop10.1\ArcCatalog\NameOfYourConnectionFile.sde"
# set the current workspace
arcpy.env.workspace = conn
# create a list of feature datasets and append an empty string to the list
lst_fds = arcpy.ListDatasets()
lst_fds.append("")
# loop through the list of feature datasets
for fds in lst_fds:
# list the featureclasses in the current dataset
fcs = arcpy.ListFeatureClasses(feature_dataset=fds)
# loop through each featureclass in the current dataset
for fc in fcs:
# do somethig with the featureclass
print fc
Kind regards, Xander
