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. Symbol Description Example * Represents zero or more characters. 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. (The default value is All)	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)