Summary
The Describe function returns the following properties for Workspace.
A workspace returns a dataType of "Workspace".
Properties
Property | Explanation | Data Type | ||||||||
connectionProperties (Read Only) | 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. | Object | ||||||||
connectionString (Read Only) | The connection string being used in conjunction with the enterprise database type. For any other workspace type, returns an empty string. | String | ||||||||
currentRelease (Read Only) | 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. | Boolean | ||||||||
domains (Read Only) | A list containing the geodatabase domain names. To work with these domain names, you can use tools from the Domains toolset. | String | ||||||||
release (Read Only) | For a geodatabase workspace, returns the geodatabase release value. Below is the mapping of geodatabase release values to ArcGIS version numbers.
| String | ||||||||
workspaceFactoryProgID (Read Only) | 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:
Tip: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.
| String | ||||||||
workspaceType (Read Only) | The workspace type.
| String |
Code sample
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)