Chapter 16, Problem 17AW

Explanation of Solution

SQL CREATE TABLE Statement:

• The “CREATE TABLE” statement creates a table with required fields.
• The format of “CREATE TABLE” is shown below:

CREATE TABLE TableName

(ColName1 DataType1,

ColName2 DataType2,

…)

• The “TableName” denotes name of table. The “ColName1” denotes name of first column, “DataType1” denotes SQL data type for first column.
• The “ColName2” denotes name of second column, “DataType2” denotes SQL data type for second column.

Example:

The example for “CREATE TABLE” is given below:

CREATE TABLE Employee

(Name CHAR(25),

Age INT(25))

Here, “Employee” denotes name of table...