SQL table builder
Add columns, set their type, nullability, default and keys — get a ready CREATE TABLE statement for your dialect.
| Name | Type | Nullable | Default | PK | Unique | |
|---|---|---|---|---|---|---|
CREATE TABLE
CREATE TABLE "users" ( "id" INTEGER NOT NULL PRIMARY KEY, "email" TEXT NOT NULL UNIQUE );
Runs in your browser. Nothing you type is sent anywhere.
How this works
- One column at a time: name, type (with dialect-specific suggestions), nullable, default value, primary key and unique.
- More than one primary-key column becomes a composite PRIMARY KEY (col1, col2) table constraint instead of an inline one.
- Identifiers are quoted correctly for the chosen dialect (double quotes, backticks or brackets).
Do this against your live database in Tablyne.
PostgreSQL GUI →FAQ
Does it validate my column types? +
No — type is a free-text field with suggestions, since valid types and their parameters (like VARCHAR(255)) vary too much across dialects to validate generically.
Can I mark more than one column as primary key? +
Yes — that produces a composite primary key as a table-level constraint, not two separate PRIMARY KEY columns.
What goes in the Default field? +
A raw SQL expression, exactly as it should appear after DEFAULT — e.g. 'active' for a string literal or now() for a function call.