Chapter 3, Problem 1RQ

Which command is used to create a table based on data already contained in an existing table?

Explanation of Solution

Command used to create a table:

• Creating table comes under Data Definition Language (DDL).
• It is useful to create a table from an existing table because the programmer does not need to copy all the data manually using an INSERT command.
• The command used to create a table depending upon the data already contained in an existing table is as follows:

  CREATE TABLE ... AS command with a subquery

• For example, consider the creation of a table named semester from an already existing table named mid_semester.

CREATE TABLE semester AS (SELECT roll_no, exam_name, grades from mid_semester);