Editing table schema

On the Column List, select/clear a column to indicate which columns are to be visible.

For the Schema Data Type column, you can change the value by clicking in the cell and selecting from the menu.

Copy and paste operations in the Table Schema List can cross sites and IDE instances. You can copy a schema and paste it into another site through the same or another IDE instance.

Saving configurations

When saving all added/modified/deleted schemas on the Table Schema List, if the current connection is opened as read-only, a warning message opens. Otherwise, it attempts to gain the connection lock for the current user.

If the user does not own the lock on the current connection, then a Lock Conflict dialog box opens. Only a user who owns the lock can save the schemas. In all other cases a warning message opens.

If the current connection is used to save the database schemas for the first time, then a sub-folder with the connection name is created under $HCISITE\formats\dbschema.

When saving table schema, added and modified table/view schemas are saved into individual schema_name.xml files.

All visible columns are saved into schema_name.vrl. If a schema has no visible columns, then a message dialog box opens asking for confirmation to continue. When you select Yes, for table schemas without visible columns the corresponding .vrl file is removed and the .xml file is updated.

All of these files are stored under $HCISITE\formats\dbschema\db_connection_name .