Use the Schema Editor to define a new in a or existing for a database (Microsoft SQL Server, MySQL, or Oracle) or for an SDF data store. You cannot create a schema for an existing SHP feature source, but you can and create a schema for it during the creation process. You must use ESRI tools to create an ArcSDE schema—you cannot use AutoCAD Map 3D to create a schema for ArcSDE.
Some FDO Providers allow the client to override the default logical and physical mapping specified in their schema. You can use the Schema Editor to override classes, physical table names (to create a new table), Oracle tablespace names, MySQL storage engines, table-type mapping (base or concrete), properties, and column names when you define a new schema. You cannot map to an existing table.
If you are mapping to an existing table or view in another , make sure all column overrides correctly map to existing columns. If you map to a table or view with a different owner, have the owner of that table grant access to the FDO data store. You can create a local view that selects from the other table, and map to the local view, but this may not be necessary. The local view is created automatically if it is not present when you apply your changes.