Creating Tables

Relational Databases

Creating Tables

🙋 Need help? Ask an expert now!

How to Create Tables

Now let's take a look into how to create a table ourselves!

The create table statement is used to create a new table. This is the format to create and simple table using SQL:

Now using the same browser from W3 schools located here, enter the following command to create your own table.

CREATE TABLE TestTable AS
SELECT customername, contactname
FROM customers;

Note: You may have as many columns as you'd like, and the constraints are optional.

Also friendly reminder… all SQL statements end with a semi-colon ;

Now lets try to create a table on your own!

Edit Me on GitHub!