Creating Tables and Designing Schemas
Learn how to create and modify tables.
Step 1: Start with a scenario
Until now, you’ve worked with tables that already existed. Now imagine you’re starting fresh, creating a new database for a small bookstore.
What kind of data would you need? Probably something like:
book titles
authors
prices
stock counts
Let’s ask AI to help us design the table.
Prompt: Write a SQL statement to create a table called books with columns for title, author, price, and stock quantity.
Powered by AI
5 Prompts Remaining
Step 2: Run and observe
AI might ...
Ask