Creating a Table

About this task

This topic explains the steps to create a table using OneDB Explore UI.

There are five types of tables:

  1. Standard table
  2. Raw table
  3. External Fixed table
  4. External Delimited table
  5. External Informix table

Standard & Raw table types are almost similar & three external table types are almost similar. This topic explains how to create both table types.

Procedure

To create a table, follow the steps given below:
  1. Go to the Schema Manager in OneDB Explore.
  2. Select desired database and click on menu option (3 dots) next to Select Database dropdown.
  3. Click on Create Table option from drop-down to create a table