To edit a schema
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.
- Connect to the feature source whose schema
you want to edit.
- In Map Explorer,
select the feature source in the connection tree (at the top of
the pane) and click Schema Edit
- 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.
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
- 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.
- 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.
- 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.
- Click Apply.
- Repeat the preceding four steps as required
to edit other schema elements.
- Click OK to make
all the changes permanent.
To rename the SQL Server Spatial provider
- Open the file fdo\bin\providers.xml.
- Find the provider name OSGeo.SQLServerSpatial.3.3.
- Change this provider name to OSGeo.SqlServerSpatial.3.3.
Note the difference in
You can now view, edit,
and apply schemas.