SQL Create Table: How-To with Example

📝 Get my free SQL Cheat Sheets: https://www.databasestar.com/get-sql-...
🎓 Master SQL Fundamentals: https://databasestar.mykajabi.com/sql...

Creating a table is one of the first things you'll need to do when working with SQL. So how do you use SQL to create a table?

There's a simple command called CREATE TABLE that you can use.

In this video, I explain what this command is. You'll also see a step-by-step example of creating a new table with a couple of columns.

Timestamps:
00:00 Start
00:18 Enter the command
00:33 Table name
01:06 Singular or plural?
01:35 Space and open bracket
01:42 Add columns
02:36 Second column
03:35 Add keys
03:58 Close brackets
04:15 Run the command
04:51 Check with Select