SQL Table Generator

Describe your columns and build a clean CREATE TABLE statement for your database.

Build a CREATE TABLE statement

Table name Dialect

One column per line: name, type, then flags such as primary, notnull, unique, auto, default:value, refs:table.column

CREATE TABLE IF NOT EXISTS Prepend DROP TABLE IF EXISTS Semicolon at the end

Columns: 0

Warnings: none

The statement is assembled locally from your column list; always review it against your own migration process.

Name the table and choose MySQL, PostgreSQL or SQLite as the dialect.
List one column per line with its type, then add flags such as primary or notnull.
Click Build statement and copy the SQL or download it as a .sql file.

Common questions about the free online sql table generator.

Name the table, list one column per line with its type and flags, then click Build statement and copy the SQL into your migration.

Start with the column name, then the type such as VARCHAR(120), then flags like primary, auto, notnull, unique or default.

MySQL, PostgreSQL and SQLite. The tool adjusts auto increment keywords, timestamp types and the table options line for each dialect.

Write a line such as id INT primary auto. MySQL gets AUTO_INCREMENT, SQLite gets AUTOINCREMENT and PostgreSQL switches the type to SERIAL.

Add refs:table.column to a column line, for example user_id INT refs:users.id, and the statement gains a FOREIGN KEY clause.

Numbers and known keywords such as CURRENT_TIMESTAMP are left unquoted. Any other value is wrapped in single quotes with quotes escaped.

The tool reports a column with no type, an unknown flag or a malformed reference so you can fix the line before running the SQL.

No. The statement is built from your text inside the browser and is never sent anywhere.

It makes the script safe to run twice, but migrations often prefer explicit versioning, so untick it if your tool manages changes.

Only the table statement. Add CREATE INDEX lines yourself after the table if a column needs a separate index.

Last updated: October 10, 2026