Table properties

Summary

The Describe function returns the following properties for tables. The Dataset property group is also supported. The Editor Tracking property group is supported if editor tracking has been enabled for this table.

Table properties are available in many types of Describe objects.

For a table, the Describe dataType property returns a value of "Table".

Properties

PropertyExplanationData Type
hasOID
(Read Only)

Indicates whether the table has an Object ID field.

Boolean
hasOID64
(Read Only)

Indicates whether the table's Object ID field is 64-bit integer. This property is only supported when the hasOID property returns True. Use the Python getattr function to avoid an AttributeError exception.

Boolean
OIDFieldName
(Read Only)

The name of the Object ID field if it exists.

String
fields
(Read Only)

A list of Field objects for the table. This property is equivalent to using the ListFields function.

Field
indexes
(Read Only)

A list of Index objects for the table. This property is equivalent to using the ListIndexes function.

Index

Code sample

Table properties example

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