Statements, Learn SQL, Codecademy, Manipulation

Lesson Summary

In this lesson, we go over creating a table in SQL. A command in SQL can also be called a clause. A clause will perform a specific task for us. When creating a table we use the 'CREATE TABLE' clause. This command does not need to be capitalized but it is convention and helps with readability. After the 'CREATE TABLE' clause we specify a table name. After the table name we put our parameters in between parentheses which are our column names and data types for our table. We will learn how to view our table in following lessons.

Subscribe To Monthly Newsletter. Chance to Win Monthly Prizes

* indicates required