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.
- 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.Add your table name
- 2.Add columns, and make sure to specify data types
- 3.Click
CREATE TABLE
When adding strings as default values, make sure to surround them in quotes.
Last modified 2yr ago