Create or Edit Tables

A step-by-step guide on how to create or edit tables in a database without writing SQL.

Creating a New Table

  1. Select the Database Connection

    • Start by choosing a database connection from DB Explorer.

    • Select the desired database from the list.

    Selected database
    Choose the database where you want to create a new table

  2. Open the Table Creation Menu

    • Hover over Tables in the database menu, right-click, and choose Create Table.
    Tables context menu
    Access the Create Table option from the context menu

  3. Define Table Structure

    • A new tab will open where you can define your table’s structure. Start by setting a table name, then add columns by clicking the + icon.

    • For each column, specify:

      • Column Name
      • Data Type
      • Nullable option (optional)
      • Identity for auto-increment (optional)
      • Default Value (optional)
    Create table interface
    Define your table structure with columns and their properties

  4. Preview SQL Code

    • Use the sidebar to preview the SQL code generated by your changes.

  5. Set Primary Key

    • Switch to the Primary Key tab, select the column(s) you want as the primary key, and apply your choice.
    Set primary key
    Define the primary key for your table

  6. Apply Changes

    • Click on Apply and Close. When prompted, confirm the changes by selecting Yes.
    Apply and close button
    Save your changes and create the table

Editing an Existing Table

  1. Select Table to Edit

    • From the database tables list, right-click on the table you want to modify and select Alter Table.
    Alter table option
    Access the table editing interface from the context menu

  2. Modify Table Structure

    • A new tab will open, allowing you to adjust the existing table structure. You can modify column details like data type, length, nullable status, identity, and default values.

    • To add new columns, click the + icon below the columns tab.

    Edit table interface
    Modify your table structure with the visual editor

  3. Apply Changes

    • Once done, click Apply and Close to confirm. A prompt will ask if you’d like to apply changes to the database. Click Yes to finalize.
    Apply changes confirmation
    Confirm and apply your changes to the database