ListTables

Summary

Lists the tables in the workspace, limited by name and table type. A Python List is returned from the function.

Discussion

The workspace environment must be set first before using several of the List functions, including ListDatasets, ListFeatureClasses, ListFiles, ListRasters, ListTables, and ListWorkspaces.

Syntax

ListTables ({wild_card}, {table_type})
ParameterExplanationData Type
wild_card

The wild card limits the results returned. If no wild card is specified, all values are returned.

String
table_type

The table type to limit the results returned by the wild card argument. Valid table types are:

  • dBASEOnly tables of type dBASE are returned.
  • INFOOnly stand-alone INFO tables are returned.
  • ALLAll stand-alone tables, including geodatabase tables, are returned. This is the default.

(The default value is All)

String
Return Value
Data TypeExplanation
String

The Python List returned from the function containing table names in the workspace, limited by the optional wild card and table type.

Code Sample

ListTables example

List all table names in workspace.

import arcpy
from arcpy import env

# Set the current workspace
#
env.workspace = "C:/Data/MyData.gdb"

# Get the list of standalone tables in the geodatabase and 
#   print to interactive window.
#
tableList = arcpy.ListTables()
for table in tableList:
    print table

Related Topics


10/28/2011