ArcGIS Pro 3.4 API Reference Guide
ArcGIS.Core.Data Namespace / SQLSyntax Class / ParseTableName Method
The fully qualified name of the table. It must not be null or an empty string.

In This Topic
    ParseTableName Method
    In This Topic
    Given a table name (fully qualified or otherwise), determines its qualification parts. This method must be called on the MCT. Use QueuedTask.Run.
    Syntax
    Public Function ParseTableName( _
       ByVal tableFullName As String _
    ) As Tuple(Of String,String,String)

    Parameters

    tableFullName
    The fully qualified name of the table. It must not be null or an empty string.

    Return Value

    A Tuple whose members contain the following data:
    1. Item1 holds the databaseName (or an empty string if it doesn't apply to the underlying Datastore).
    2. Item2 holds the ownerName (or an empty string if it doesn't apply to the underlying Datastore).
    3. Item3 holds the tableName.
    Exceptions
    ExceptionDescription
    tableFullName is null or an empty string.
    With the error message The specified parameter value is invalid if tableFullName contains a databaseName component when the underlying Datastore is an enterprise geodatabase on Oracle.
    A geodatabase-related exception has occurred.
    Remarks

    Applications should use the ParseTableName method to split the fully qualified name of a table into its components (database, owner, table). ParseTableName can also be used to return the components of any fully qualified name of a dataset such as feature classes, and feature datasets.

    Applications that wish to be RDBMS independent should not assume that '.' is the delimiter used to separate the components of a fully qualified dataset name. Use the QualifyTableName method to determine the qualified name of a dataset for a given Datastore.

    Empty strings will be returned for arguments that do not apply to the underlying Datastore. For example, supplying a tableFullName argument of "gdb.MyTable" to an enterprise geodatabase on Oracle will result in:

    • databaseName = ""
    • ownerName = "gdb"
    • tableName = "MyTable"

    Requirements

    Target Platforms: Windows 11, Windows 10

    ArcGIS Pro version: 3 or higher.
    See Also