The Describe function returns the following properties for Workspace.
A workspace returns a dataType of "Workspace".
connectionProperties is a property set. The connection properties for an enterprise geodatabase workspace will vary depending on the type of enterprise database being used. Possible properties include the following:
Only one of historical_name, historical_timestamp, or version exists for any given workspace.
The connection string being used in conjunction with the enterprise database type. For any other workspace type, returns an empty string.
For a geodatabase workspace, returns True if the geodatabase's version is current. currentRelease can be used to assess if the geodatabase can be upgraded.
A list containing the geodatabase domain names. To work with these domain names, you can use tools from the Domains toolset.
For a geodatabase workspace, returns the geodatabase release value. Below is the mapping of geodatabase release values to ArcGIS version numbers.
The ID is a string. You can use this to distinguish between specific workspace types with a finer granularity than you can with workspaceType. For example, workspaceFactoryProgID can distinguish between a file geodatabase and a personal geodatabase. Using workspaceType, you cannot make that distinction.
Following are workspaceFactoryProgID strings returned for the common workspace types:
The workspace type.
Workspace properties example (stand-alone script)
The following stand-alone script displays some workspace properties for an enterprise database.
import arcpy # Create a Describe object for an SDE database # desc = arcpy.Describe(r"C:data\Connection to state.sde") # Print workspace properties # print "%-24s %s" % ("Connection String:", desc.connectionString) print "%-24s %s" % ("WorkspaceFactoryProgID:", desc.workspaceFactoryProgID) print "%-24s %s" % ("Workspace Type:", desc.workspaceType) # Print Connection properties # cp = desc.connectionProperties print "\nDatabase Connection Properties:" print "%-12s %s" % (" Server:", cp.server) print "%-12s %s" % (" Instance:", cp.instance) print "%-12s %s" % (" Database:", cp.database) print "%-12s %s" % (" User:", cp.user) print "%-12s %s" % (" Version:", cp.version) # Print workspace domain names" # domains = desc.domains print "\nDomains:" for domain in domains: print "\t" + domain