a apiary.
← All tools

SQL / BROWSER UTILITY

SQL CREATE TABLE Builder

Generate CREATE TABLE statements with column types, defaults and primary keys for your SQL dialect.

Processed locally in your browser. Your SQL is not uploaded or executed.

Enter names, not expressions. Use dialect quotes around names with spaces. Ordinary Oracle names use uppercase; ordinary PostgreSQL names use lowercase. Text values are escaped, never executed.

Columns

Apiary never executes SQL. Review the statement against your database before using it. Oracle treats empty text as NULL. SQLite uses type affinities and does not enforce declared text lengths or decimal precision.

Good to know

Choose columns, portable types, nullability and primary-key fields. Open Default value for optional typed defaults. Dialect-specific types are generated automatically; advanced database features such as sequences and generated columns are outside this builder.

Example: Create products with a product_name text column and an integer product_id primary key.