Learn

CREATE statements allow us to create a new table in the database. You can use the CREATE statement anytime you want to create a new table from scratch. The statement below creates a new table named celebs.

CREATE TABLE celebs ( id INTEGER, name TEXT, age INTEGER );

1. CREATE TABLE is a clause that tells SQL you want to create a new table.
2. celebs is the name of the table.
3. (id INTEGER, name TEXT, age INTEGER) is a list of parameters defining each column, or attribute in the table and its data type:

  • id is the first column in the table. It stores values of data type INTEGER
  • name is the second column in the table. It stores values of data type TEXT
  • age is the third column in the table. It stores values of data type INTEGER

Instructions

1.

Now that you have a good understanding of SQL syntax, we can create a new table. We’ve cleared the database from the previous exercises. Confirm no celebs table exists by entering the following in the code editor:

SELECT * FROM celebs;

Look at the results. The database should be empty!

2.

Now that we know the database is empty, let’s create a new celebs table.

In the code editor, type:

CREATE TABLE celebs ( id INTEGER, name TEXT, age INTEGER );

We will learn how to view this table in a later exercise after we have added some data to it.

Take this course for free

Mini Info Outline Icon
By signing up for Codecademy, you agree to Codecademy's Terms of Service & Privacy Policy.

Or sign up using:

Already have an account?