Answers

Question and Answer:

  Home  SQL

⟩ What command is used to create a table by copying the structure of another table?

CREATE TABLE .. AS SELECT command

Explanation:

To copy only the structure, the WHERE clause of the SELECT command should contain a FALSE statement as in the following.

CREATE TABLE NEWTABLE AS SELECT * FROM EXISTINGTABLE WHERE 1=2;

If the WHERE condition is true, then all the rows or rows satisfying the condition will be copied to the new table.

 148 views

More Questions for you: