To Edit a Schema

You can edit a schema , feature class , or property if the FDO provider supports updateable schemas (for example, Microsoft SQL Server, SQL Server Spatial, MySQL, Oracle, and SDF all support updateable schemas).

To edit a schema

  1. Connect to the feature source whose schema you want to edit.
  2. In Map Explorer, select the feature source in the connection tree (at the top of the pane) and click SchemaEdit Schema.
  3. In the Schema Editor, expand the Schema tree and click the schema, feature class, or property to edit.

    The current settings appear in the right-hand pane.

  4. Edit the settings for the schema element.

    The settings you can change depend on what the provider supports and which settings are editable. For example, the long transaction section does not appear or is unavailable if the provider does not support versioning.

  5. To add a new feature class, select the schema entry on the right and click New Feature Class at the top of the window. Specify the information for the new feature class on the left side of the window.
  6. To add a new property, select the feature class entry for that property on the right and click New Property at the top of the window. Specify the information for the property on the left side of the window.

    See To Add Constraints Using the Schema Editor for information on limiting the valid values for a property.

  7. For a feature class and property, click the Physical Configurations tab and edit the physical settings if necessary.

    Each provider maps a correspondence between a schema element and a physical object in a feature source. The physical structure of feature sources varies by provider, as do the types of schema mappings and default settings. Oracle, for example, maps each feature class onto a table in the Oracle database where the feature source resides, giving the class and table the same name. You can override these defaults by changing the settings on the Physical Configurations tab. The settings on this tab vary by provider. The tab is unavailable for providers whose defaults cannot be changed.

  8. Click Apply.
  9. Repeat the preceding four steps as required to edit other schema elements.
  10. Click OK to make all the changes permanent.

Related Concepts