English

Problem: Apostrophes are not handled correctly with feature dataset names

Description

Feature dataset names containing apostrophes can not be deleted or renamed in ArcCatalog or with ArcObjects.

Cause

Apostrophes are not handled correctly with feature dataset names. The apostrophe should be contained in single quotes. For example:

"Select NAME from MYTABLE where NAME = 'test''s'

This is a problem in ArcSDE and Personal Geodatabases.

Solution or Workaround

First, do not use apostrophes in feature dataset names. To delete:

  1. Go into the native SQL environment for the database; for example, SQLPlus, Access, Enterprisemanager. Find the feature dataset name in the GDB_FEATUREDATASET table.

    Code:
    "select NAME from GDB_FEATUREDATASET where NAME = 'test''s'"

  2. Update the feature dataset name to something usable.
    Code:
    "update sde.sde.GDB_FEATUREDATASET set NAME = 'test_s' where NAME = 'test''s'"

  3. Delete the featuredataset in ArcCatalog.