Importing table/view schema

  1. 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.

  2. 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.
  3. Click Refresh to reload the table/view list.
  4. Select a table or view.
  5. 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.