Importing table/view schema
-
Click Import to add the schemas into the Table Schema List. This is
always enabled.
If the current database connection is opened as read-only, then a warning message pops up.
Otherwise, the Import Table Schema dialog box opens.
-
Select a table or view to populate Column List.
This shows all the tables and views under the current database connection, and all the columns of the currently selected table/view. Tables are sorted by clicking the column header.
- Click Refresh to reload the table/view list.
- Select a table or view.
-
Click
OK to add the selected
table/view schemas into the Table Schema List of the Database Schema
Configurator.
Note: OK is not available until a table or view is selected.
- By default, all columns of the imported tables/views are visible and the corresponding Schema Data Type is String.
- The valid table/view name only accepts letter, digits, and underscores. Invalid table/views are disabled and cannot be selected from the left pane.
- If the selected table/view is already on the Schema List, then a message pops up to ask for confirmation to overwrite the existing entry.
Note: When using the Table Schema Properties dialog box (Database Schema Configurator > Options > Table Schema Options), double quotes are not supported for Field Separator or Termination for table schema.