Chapter 3, Problem 1SCG

Program Plan Intro

Table Creation:

Creating table comes under Data Definition Language (DDL).

• The “CREATE TABLE” command is used to create a table by specifying the table name and then by listing the column in a single set of parentheses in the table.
• The “CREATE” command is employed for establishing databases on our platform by constructing tables in an already existing database.

The Syntax for creating table is as follows:

CREATE TABLE TABLE_NAME (

  Column1 datatype,

  Column2 datatype,

);