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.
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.