Question: What command is used to create a table by copying the structure of another table?Answer: CREATE TABLE .. AS SELECT commandExplanation: 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. |
Is it helpful?
Yes
No
Most helpful rated by users: