SQL Create Table: How-To with Example

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.

Creating a table in SQL works the same way in all major databases, such as Oracle, SQL Server, MySQL, and PostgreSQL. The example used in this video will work on all of those databases.

There are a range of extra options you can specify when creating a table, such as where and how it's stored, and the keys and constraints, but they will all be covered in a separate video. This video will teach you the basics of creating a table so you can get up and running.

If you want to read the article on this topic, I've written an in-depth guide to the CREATE TABLE statement here: https://www.databasestar.com/sql-create-table/

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

/// RESOURCES
Get my free SQL Cheat Sheets for Oracle, SQL Server, MySQL, and Postgres here: https://www.databasestar.com/get-sql-cheat-sheets/
SQL Roadmap: an overview of SQL topics, which is a great place to start: https://www.databasestar.com/sql-roadmap/
Contact me here for questions, sponsorship requests, and more: https://www.databasestar.com/contact/
Want to take your database and SQL skills to the next level? Sign up for Database Star Academy, the online platform for database development and SQL. Check it out here: https://www.databasestar.com/dsa/