To Create a Feature Class that Maps to a Database View

A database view is a virtual or logical table composed of the result set of a query.

To create a feature class that maps to a database view

1. Create an FDO-enabled data store.

   You can use the Schema Editor to do this. See To Create a Schema.

2. Create a database view using the native tools for your database.

   For Oracle, use sqlplus. For SQL Server, use sqlcmd. For MySQL, use mysql.

3. Reconnect to the data store in AutoCAD Map 3D.
4. In the Schema Editor, select the target schema Name and click New Feature Class.

   For information about creating feature classes and properties, see To Edit a Schema.

5. If the Logical Feature Class tab is displayed, click the Physical Configurations tab.
6. For Table Name, type the name of the view you created in step 1. Click OK.
7. Switch back to the Logical Feature Class tab and type the name, class type, and other required information.
8. Click New Property to add a property.
9. Switch to the Physical Configuration tab.
10. Type the name of the view column (from the view you created in step 1) to map to the new property. Click OK.
11. Switch back to the Logical Property tab and set the property attributes.
12. Repeat steps 8 through 11 to create the remaining properties.
13. Be sure to fill in the Primary Key column for the new view record before you check it in (if it is not defined to be auto-generated).