In Map Explorer, select the in the connection tree (at the top of the pane) and click SchemaEdit Schema.
You cannot control every aspect of a schema from the Schema Editor. For example, you cannot create object or association properties, or specify that the system auto-generate a value for a property. However, if you have set up these attributes for a schema, the Schema Editor will display the current settings.
Export the selected schema as an XML file to share a schema you created in the Schema Editor with other AutoCAD Map 3D or GIS-software users; to back up a schema you created in the Schema Editor as an XML file; or to save your work in progress if the original data source or directory becomes unavailable.
Define a new schema in a new or existing feature source for a database FDO provider (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 create a new file-based data store and create a new 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.
Feature Class Settings
A non-feature class has no association with another class and requires a unique identifier. As a contained class, it defines a property of another non-feature or feature class. For example, Sidewalk could be a property of a Road feature class; the Sidewalk class defines the Road.Sidewalk property. In this case, the Sidewalk class does not need an identity property, although it could have one.
Select the properties that comprise the unique identifier (for non-null primary-key values) for this feature class. Select one property for a simple identifier or multiple properties for a compound identifier. (Some providers support only simple identifiers). Create these properties before you create any others. Use the arrow buttons to reorder the properties.
Ordinarily, identifier properties use an auto-generated integer. This means that when you add new features to this feature class, they automatically receive an auto-generated, unique identifier. If you do not specify an auto-generated integer for this property, you must manually enter a unique identifier for each new feature that uses it.
Specify the criteria features must meet in order to be added to this feature class. Enter a constraint for this feature class in the Constraints box and click New to apply it. Create additional constraints if necessary. Use the arrow buttons to reorder the constraints. To remove a constraint, select it and click Delete. This setting is available only if the provider supports constraints. Constraint syntax is provider-specific.
A Data property data type is either boolean, byte, date/time, decimal, single, double, Int16, Int32, Int64, or string. For example, a Road feature can have a data property called DateConstructed whose data type is date/time.
The default Geometry property specifies one of four shapes: point (0 dimensions), curve/line (1 dimension), surface/polygon (2 dimensions), and solid (3 dimensions). A feature class has one main geometry property, but can have additional geometry properties. A geometry property is associated with a spatial context. All instances of a geometric property must have the same ordinate dimension. Not all providers support all geometry types or all dimensionalities; SHP supports only XY points, for example, whereas Oracle supports XY, XYZ, XYZM, and XYM points. The default is XY. Additionally, it can have attributes that describe elevation and measure: HasElevation for Z and HasMeasure for M.
A feature class has one main geometry property, but can have additional geometry properties. A geometry property is associated with a spatial context. All instances of a geometric property must have the same ordinate dimension. Not all providers support all geometry types or all dimensionalities; SHP supports only XY points, for example, whereas Oracle supports XY, XYZ, XYZM, and XYM points. The default is XY. Additionally, it can have attributes that describe elevation and measure: HasElevation for Z and HasMeasure for M.
The association property may appear in the list, but it is not supported by AutoCAD Map 3D. Choose this property type only if existing data uses it and you want to maintain that data after it is moved to a different data store.
Click an attribute name in the schema tree to display its description. If you can change or specify the value for a property, a down-arrow or a blinking cursor appears in its field and you can select or enter a value.