Skip to main content

ParseTableName

Summary

Parses a table name into its components (database, owner, table) depending on the workspace. ParseTableName returns a string containing the parsed table name, with the database name, owner name, and table name, separated by commas. This workspace must be a file or enterprise geodatabase.

Syntax

ParseTableName(name, {workspace})

Parameter Explanation Data Type

name

Specifies which table will be parsed.

String

workspace

Specifies the workspace for fully qualifying the table name. The workspace must be a file or enterprise geodatabase.

String

Return value

Data Type Explanation

String

Returns the table name parsed into its components (database name, owner name, table name), separated by commas.

Code sample

ParseTableName example

Parse a table name into its components.

import arcpy

field_name = arcpy.GetParameterAsText(0)
workspace = arcpy.GetParameterAsText(1)

# Parse the table name into database, owner, and table
fullname = arcpy.ParseTableName(field_name, workspace)
database, owner, table = fullname.split(", ")