Skip to content

Tables

Tables are only available on relational databases.

Create a table

Open a database → click New Table:

  1. Set the table name
  2. Add columns — each column has:
FieldDescription
NameColumn identifier
TypeINT, BIGINT, VARCHAR, TEXT, FLOAT, BOOLEAN, DATE, DATETIME
LengthOnly for VARCHAR (default 255)
PKPrimary key — only one per table
NullableWhether NULL is allowed
UniqueEnforces unique constraint
Auto-incrementAuto-increments on insert (use with INT PK)
DefaultOptional default value

Best practice

Always include an id INT PK AUTO_INCREMENT column — Celdrax pre-fills it for you.

View table schema

Click the chevron on any table card to expand and see all columns with their types and constraints.

Drop a table

Click the trash icon on the table row. Irreversible — all data in the table is lost.