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

In This Topic
    ParseColumnName Method
    In This Topic
    Given a column name (fully qualified or otherwise), determines its qualification parts. This method must be called on the MCT. Use QueuedTask.Run.
    Syntax

    Parameters

    columnFullName
    The fully qualified name of the column. 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.
    4. Item4 holds the columnName.
    Exceptions
    ExceptionDescription
    columnFullName is null or an empty string.
    With the error message The specified parameter value is invalid if columnFullName 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 ParseColumnName method to split the fully qualified name for a column in a table into its components (database, owner, table, column).

    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 QualifyColumnName method to determine the qualified name of a column of a table for a given Datastore.

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

    • databaseName = ""
    • ownerName = "gdb"
    • tableName = "Greeley_Parcels_1"
    • columnName = "AREA"

    Requirements

    Target Platforms: Windows 11, Windows 10

    ArcGIS Pro version: 3.0 or higher.
    See Also