SQLCreateTable.com

Back to Designer

SQLCreateTable.com Documentation

Learn how to use our visual database designer tool

Table of Contents

Getting Started with SQL Create Table

SQL Create Table is a visual database design tool that helps you create database schemas without writing SQL code manually. You can design tables, define relationships, and generate SQL code for multiple database systems.

Key Features

  • Visual table designer with support for columns, data types, and constraints
  • Relationship management for defining connections between tables
  • SQL generation for PostgreSQL, MySQL, SQL Server, SQLite, and Oracle
  • Import and export functionality for saving and sharing your designs
  • Community templates for common database scenarios

Basic Workflow

  1. Create a new table using the sidebar
  2. Define columns with appropriate data types and constraints
  3. Create relationships between tables
  4. Generate SQL code for your chosen database system
  5. Save or export your design for future use

Creating Tables

How to Create a New Table

Creating a new table in SQL Create Table is simple:

  1. Click the "New Table" button in the sidebar
  2. Enter a name for your table (use lowercase and underscores for best practices)
  3. Click "Create" to add the table to your schema

Best Practices for Table Names

  • Use plural nouns (e.g., "users" instead of "user")
  • Use lowercase letters and underscores (snake_case)
  • Be descriptive but concise
  • Avoid reserved SQL keywords

Example Tables

users

Stores user account information

products

Stores product information

orders

Stores order information

order_items

Stores items within orders

Defining Columns

After creating a table, you'll need to define its columns. Each column has a name, data type, and optional constraints.

Adding and Configuring Columns

  1. Click "Add Column" in the table designer
  2. Enter a name for your column
  3. Select an appropriate data type
  4. Configure constraints (NOT NULL, UNIQUE, etc.)
  5. Set a default value if needed
Best Practices for Column Names
  • Use lowercase letters and underscores
  • Be descriptive but concise
  • Use "id" for primary key columns
  • Use "created_at" and "updated_at" for timestamps
  • Use "_id" suffix for foreign key columns

Managing Relationships

Creating Table Relationships

Relationships define how tables are connected to each other. SQL Create Table supports one-to-one, one-to-many, and many-to-many relationships.

Types of Relationships

One-to-One

Each record in Table A is related to exactly one record in Table B.

Example: user ↔ profile

One-to-Many

Each record in Table A can be related to multiple records in Table B.

Example: user ↔ posts

Many-to-Many

Records in Table A can be related to multiple records in Table B and vice versa.

Example: students ↔ courses

Creating a Relationship

  1. Click "Manage Relations" in the sidebar
  2. Select the relationship type (one-to-one, one-to-many, many-to-many)
  3. Choose the source table and column
  4. Choose the target table and column
  5. Give the relationship a name (e.g., "fk_posts_users")
  6. Click "Add Relationship"
Example Relationship SQL
-- One-to-Many relationship between users and posts
CREATE TABLE users (
  id INT PRIMARY KEY,
  username VARCHAR(50) NOT NULL UNIQUE
);

CREATE TABLE posts (
  id INT PRIMARY KEY,
  user_id INT NOT NULL,
  title VARCHAR(255) NOT NULL,
  CONSTRAINT fk_posts_users FOREIGN KEY (user_id) REFERENCES users(id)
);

Generating SQL

Creating SQL Code

Once you've designed your tables and relationships, you can generate SQL code for your chosen database system.

Supported Database Systems

PostgreSQL
MySQL
SQL Server
SQLite
Oracle

Generating SQL Code

  1. Click "Generate SQL" in the sidebar
  2. Select your target database system
  3. Review the generated SQL code
  4. Copy the code or download it as a file
SQL Code Features
  • CREATE TABLE statements for all tables
  • Column definitions with data types and constraints
  • Foreign key constraints for relationships
  • Database-specific syntax optimizations
  • Comments for better readability

Frequently Asked Questions

Is SQL Create Table free to use?

Yes, SQL Create Table is completely free to use with no limitations.

Do I need to create an account?

No, you don't need an account to use SQL Create Table. Your designs are saved in your browser's local storage.

Can I use SQL Create Table offline?

Once loaded, SQL Create Table can work offline, but you'll need an internet connection to access it initially.

How do I share my database design with others?

You can export your design as JSON and share the file, or generate SQL code and share that.

Can I import an existing database schema?

Currently, you can only import designs created with SQL Create Table. Direct import from existing databases is planned for a future update.