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 .1 following the string returned by workspaceFactoryProgID is only present in 64-bit products. If writing code that will be used against 32-bit and 64-bit products, use the string method startswith.
The workspace type.
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)