SQL Table Creator

This is a SQL table creator for Postgres, MySQL, SQL Server, SQLite, and Redshift databases from the makers of Beekeeper Studio. Create a SQL table below using the point and click UI, then copy the output SQL into your database.
edit

Columns

add
 
Name
Type
Nullable
Default Value
Comment
Primary
 
id
autoincrement
(NULL)
(NULL)
clear
first_name
varchar(255)
(NULL)
(NULL)
clear
last_name
varchar(255)
(NULL)
(NULL)
clear
email
varchar(255)
(NULL)
(NULL)
clear
created_at
timestamp
NOW()
(NULL)
clear
updated_at
timestamp
NOW()
(NULL)
clear

CREATE TABLE Generated SQL (Postgres)

create table "users" (
  "id" serial primary key,
  "first_name" varchar(255) null,
  "last_name" varchar(255) null,
  "email" varchar(255) not null,
  "created_at" timestamp not null default NOW(),
  "updated_at" timestamp not null default NOW()
)

Make SQL Fun Again With Beekeeper Studio

This SQL table creator is just one of several useful features built into Beekeeper Studio, the SQL editor and database GUI that makes writing SQL fun again. Available for Linux, MacOS, and Windows.

Beekeeper Studio example

Get Started Free