When copying data into a geodatabase, underscores are added to object names

Last Published: April 25, 2020


When copying data into a geodatabase, objects are renamed to include an underscore character.


The original name of the object corresponds to a reserved keyword in the underlying destination DBMS.


Rename the object in the origin geodatabase to a name that does not conflict with any reserved keywords in the destination DBMS and copy the data again.

The following code example can be used to get the list of reserved keywords. Select the Geodatabase in ArcCatalog and run the macro.
Public Sub GetDatabaseKeywords()
Dim pApp As IGxApplication
Dim pGxObj As IGxObject
Dim pGxDB2 As IGxDatabase2
Dim pSDEWS As IWorkspace
Dim pSQLSyntax As ISQLSyntax
Dim pDBConnInfo As IDatabaseConnectionInfo

Set pApp = Application
Set pGxObj = pApp.SelectedObject
'If for some reason we're not connected to a GDB, Exit
If Not TypeOf pGxObj Is IGxDatabase2 Then Exit Sub
Set pGxDB2 = pGxObj
Set pSDEWS = pGxDB2.workspace

Set pSQLSyntax = pSDEWS

Dim pEnumBSTR As IEnumBSTR
Dim str As String
Set pEnumBSTR = pSQLSyntax.GetKeywords
str = pEnumBSTR.Next
Do Until str = ""
Debug.Print str
str = pEnumBSTR.Next

End Sub

    Article ID:000006581

    • ArcMap 8 x
    • ArcMap 9 x

    Get help from ArcGIS experts

    Contact technical support

    Download the Esri Support App

    Go to download options

    Discover more on this topic