Creating a table using OneDB Explore

About this task

This topic provides the steps to create a table.

Procedure

1. Select the required database from the Select Database drop-down list and click on … to select the Create Table option.
   
2. Enter a unique table name and select the table type from the drop-down list. Following is an example of Standard table type.
   
3. Click Add Columns to add the columns for this table. Enter the column name and select datatype from the given list and click Add. Enter the require details.
   
4. Click Close and click Next.
   
5. You can choose the Primary key from the available column list and define Foreign Key and Unique Key as per the requirement. Either click View SQL button to directly view the SQL query constructed with the default settings or click Advance Table Options button.
   
6. You can modify the default table options in this page and click View Query & Create button.
   
7. If the constructed query is as expected, click Create to create the table. Otherwise click Back to modify as per the requirement.
   

Results

A new table is created, and select Info tab to view the details.