The Describe function returns the following properties for a workspace.
For a workspace, the Describe dataType property returns a value 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, version, or branch 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. The currentRelease property can be used to assess whether 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 that you can use to distinguish between workspace types with a finer granularity than you can with workspaceType.
The following are workspaceFactoryProgID values returned for common workspace types:
Prior to ArcGIS Pro 3.0, a memory workspace would return a value of esriDataSourcesGDB.ColumnaDBWorkspaceFactory.1.
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)