Table properties

Summary

The Describe function returns the following properties for Tables. Dataset Properties are also supported.

Table properties are available in many types of Describe objects.

Properties

Property	Explanation	Data Type
hasOID (Read Only)	Indicates whether the table has an ObjectID field.	Boolean
OIDFieldName (Read Only)	The name of the OID field if it exists.	String
fields (Read Only)	A Python list of Field objects for this table. This is the same as using the ListFields function.	Object
indexes (Read Only)	A Python list of Index objects for this table. This is the same as using the ListIndexes function.	Object

Code Sample

Table properties example (stand-alone script)

The following stand-alone script displays the OID field name if the table has one. It then prints the name and type for each field in the table.

import arcpy

# Create a Describe object from the table.
#
desc = arcpy.Describe("C:/data/chesapeake.gdb/munich")

# If the table has an OID, print the OID field name
#
if desc.hasOID:
    print "OIDFieldName: " + desc.OIDFieldName

# Print the names and types of all the fields in the table
#
for field in desc.fields:
    print "%-22s %s %s" % (field.name, ":", field.type)
    #print field.name + " = " + field.type