Skip To Content

ListTables

Summary

Lists the tables in the workspace, limited by name and table type.

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 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

# Set the current workspace
arcpy.env.workspace = "c:/data/mydata.gdb"

# Get and print a list of tables
tables = arcpy.ListTables()
for table in tables:
    print(table)

Related topics