Skip To 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 personal, file, or enterprise geodatabase.

Syntax

ParseTableName (name, {workspace})
ParameterExplanationData Type
name

Specifies which table will be parsed.

String
workspace

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

String
Return Value
Data TypeExplanation
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(", ")

Related topics