ListTables

Summary

Returns a list of tables in the current workspace.

Discussion

If database views exist within the workspace, they will be returned among the list of tables.

The workspace environment must be set 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

Limits the results returned. If a value is not specified, all values are returned. The wildcard is not case sensitive.

SymbolDescriptionExample

*

Represents zero or more characters.

Te* finds Tennessee and Texas.

String
table_type

The table type to limit the results.

  • 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 arguments.

Code sample

ListTables example

List all table names in the 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