Editing a Schema
Concept Procedure

To edit a schema

NoteIf you edit the Schema for a survey data store, make sure that you do not inadvertently remove existing fields or classes. Doing so may affect the performance of the survey data store.
  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 Schema Edit 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 Setting Up Constraints in 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.

To rename the SQL Server Spatial provider

  1. Open the file fdo\bin\providers.xml.
  2. Find the provider name OSGeo.SQLServerSpatial.3.3.
  3. Change this provider name to OSGeo.SqlServerSpatial.3.3.

    Note the difference in capitalization.

You can now view, edit, and apply schemas.