Add tables and columns to a database meta-schema

You can add tables and columns to a meta-schema.

To add a table, right-click in the background of the meta-schema diagram and select Add Table. A new table with a single column is added.

To add a column to a table, right-click on the table and select Add Column.

Set properties for a table or a column by selecting the item in the diagram or Structure view and editing its properties in the Properties view.

Database views

If a database view exists in the underlying database, it appears in the database meta-schema diagram; however, views cannot be added in the manner as tables and columns.

To add views to the database, you must create the view in the database itself using SQL; to then add a newly-created view to the meta-schema diagram, you must refresh the meta-schema. To refresh the meta-schema, right-click on the meta-schema file in the Projects view and select Update schema....