The command, CREATE TABLE AS LEVEL1_CUSTOMER FROM CUSTOMER; creates a table called LEVEL1_CUSTOMER that has the same structure as CUSTOMER.

Name: The command, CREATE TABLE AS LEVEL1_CUSTOMER FROM CUSTOMER; creates a table called LEVEL1_CUSTOMER that has the same structure as CUSTOMER.
Brand: Quizplus
Rating: 4.8 (37 reviews)

Question

Quizplus · Accepted Answer

The correct SQL syntax to create a table with the same structure as another is "CREATE TABLE LEVEL1_CUSTOMER AS SELECT * FROM CUSTOMER;".

The Command, CREATE TABLE AS LEVEL1_CUSTOMER FROM CUSTOMER; Creates a Table