Editing a Metadata Model

Editing metadata models is simpler than editing view models because there is only one type of element in the model—a table. There are no connections between tables. Every table has a name and zero or more column definitions.

To edit a metadata model after you have deployed it, you must first undeploy the model.

  1. To open an existing metadata model for editing, click the Navigator tab in the left pane. Navigate to the folder where your model is stored and double-click the .amm file for the model. The model opens in the editor pane.
  2. To add a new table to the metadata model, click the palette to the left of the editor pane and click New Table.
  3. Click in the editor pane to insert the new table. The table appears with no columns defined.
  4. You can also copy and paste tables from this model or from another model:
    1. Select the tables you want to copy.
    2. Right-click and select Copy ... Tables.
    3. Right-click in the model you want to paste the tables into and select Paste ... Tables.
    The copied tables appear in the model.
  5. To edit a table, double-click it. The Schema Editor window appears.
  6. In the Name field, replace the auto-filled name "NewTable."
  7. (Optional) Click Edit and type a description for your table.
  8. Click Add to add a new column to your table, and then position your cursor in the column fields to edit their names and values. Columns are numbered to help you quickly pinpoint schema errors, which appear at the bottom of the Schema Editor window as in the following example.


  9. Continue to click Add and enter data until your table contains all the columns you need.
  10. (Optional) To reposition a column, select its row and click Move Up or Move Down.
  11. When you have finished adding and editing columns, click OK.
  12. To remove a table from the metadata model, right-click it and select Delete.
  13. Type Control-s to save your changes to the metadata model.
Related concepts
Metadata Models
Related tasks
Importing a Metadata Model
Creating a Metadata Model
Deriving a View Model from a Metadata Model
Mapping a Metadata Model to a Grid Object
Deleting a Metadata Model
Undeploying a Metadata Model

Send your feedback on this help topic to Sybase Technical Publications: pubs@sybase.com

Your comments will be sent to the technical publications staff at Sybase, Inc. For product-related issues or technical support, contact Sybase Technical Support at 1-800-8SYBASE.