How do the dialects differ?

Auto-increment differs the most: MySQL uses AUTO_INCREMENT, PostgreSQL uses SERIAL or GENERATED, and SQLite uses INTEGER PRIMARY KEY AUTOINCREMENT. The builder adjusts the syntax for the dialect you pick.

What does NOT NULL do?

NOT NULL forbids a column from storing a missing value, so every inserted row must supply it. Leaving it off lets the column hold NULL.

Can I set a primary key?

Yes. Mark one or more columns as primary key. A single primary key is inlined on the column, while multiple primary key columns produce a composite PRIMARY KEY constraint at the end.

What is a default value?

A DEFAULT supplies a value when an INSERT omits the column, for example DEFAULT CURRENT_TIMESTAMP for a created_at column. The builder quotes string defaults automatically.

Does it add IF NOT EXISTS?

Yes, you can toggle CREATE TABLE IF NOT EXISTS, which prevents an error if the table already exists. All three supported dialects accept this clause.

SQL CREATE TABLE Statement Builder

Email me this result

Get this tool's output sent to your inbox, plus one useful tool a week. No spam, unsubscribe any time.

SQL CREATE TABLE Statement Builder

Writing DDL by hand is error prone, especially across database engines that disagree on auto-increment and type syntax. This builder turns a list of columns into a clean, valid CREATE TABLE statement for MySQL, PostgreSQL, or SQLite, handling primary keys, nullability, defaults, and dialect quirks for you.

How it works

For each column the builder emits name type followed by modifiers in canonical order: a PRIMARY KEY or auto-increment clause, then NOT NULL, then DEFAULT. Auto-increment is dialect specific:

MySQL: INT AUTO_INCREMENT PRIMARY KEY
PostgreSQL: SERIAL PRIMARY KEY
SQLite: INTEGER PRIMARY KEY AUTOINCREMENT

When more than one column is a primary key, it instead appends a composite PRIMARY KEY (a, b) constraint at the end. String and date defaults are wrapped in single quotes, while numeric and keyword defaults such as CURRENT_TIMESTAMP are left bare.

Tips and example

A typical generated statement looks like:

CREATE TABLE IF NOT EXISTS users (
  id INT AUTO_INCREMENT PRIMARY KEY,
  email VARCHAR(255) NOT NULL,
  created_at TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP
);

Pick the dialect that matches your target database before copying, since the auto-increment line will differ. Mark exactly one auto-increment column. For lookup columns you query often, plan an index separately after the table is created.