Skip to main content

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

Parameter Explanation Data Type

wild_card

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

Use an asterisk (*) to represent zero or more characters. For example, Te* finds Tennessee and Texas.

String

table_type

The table type to limit the results.

  • dBASE—Only tables of type dBASE are returned.

  • INFO—Only stand-alone INFO tables are returned.

  • ALL—All stand-alone tables, including geodatabase tables, are returned. This is the default.

String

Return value

Data Type Explanation

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)