Links

Creating a Table

Create a table with foreign keys, checks, and constraints in the graphical editor.
Arctype allows you to create a table with the click of a button. Often, it is faster to create a table and then modify its schema later, or to create a table with inputs instead of SQL.

Create a Table

To create a Table:

  • Click SQL Client in the left sidebar
  • Select Tables in the SQL Client menu
  • Click the ••• button and select Create Table
A popup will appear allowing you to choose the schema for your table. Next, specify your schema.
To create a schema for your Table:
  1. 1.
    Add your table name
  2. 2.
    Add columns, and make sure to specify data types
  3. 3.
    Click CREATE TABLE
When adding strings as default values, make sure to surround them in quotes.
To read more about editing a table, check out how to View/Edit a Table Schema