Workspace properties

Summary

The Describe function returns the following properties for Workspaces.

A Workspace returns a dataType of "Workspace".

Properties

Property	Explanation	Data Type
connectionProperties (Read Only)	The connectionProperties is a property set. The connection properties for an enterprise geodatabase workspace will vary depending on the type of SDE database being used.	Object
connectionString (Read Only)	The connection string being used in conjunction with the SDE database type. For other workspace types, this string is always empty.	String
domains (Read Only)	A Python List containing the geodatabase domain names. To work with these domain names, you can use tools from the Domains_toolset.	String
workspaceFactoryProgID (Read Only)	The ID as 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: esriDataSourcesGDB.FileGDBWorkspaceFactory.1 —File geodatabase esriDataSourcesGDB.AccessWorkspaceFactory.1 —Personal geodatabase esriDataSourcesGDB.SdeWorkspaceFactory.1 —SDE geodatabase (empty string) —Other (Shapefile, coverage, CAD, VPF, and so on).	String
workspaceType (Read Only)	The workspace type. FileSystem —File-based workspaces (coverages, shapefiles and so forth). LocalDatabase —Geodatabases that are local (a file or personal geodatabase). RemoteDatabase —Geodatabases that require a remote connection (ArcSDE, OLE DB, and so forth)	String

Code Sample

Workspace properties example (stand-alone script)

The following stand-alone script displays some workspace properties for an SDE 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