In SQL, which command is used to create a copy of an existing table?OptionsCREATE TABLE ASDUPLICATE TABLECOPY TABLECLONE TABLE

The correct command to create a copy of an existing table in SQL is "CREATE TABLE AS". This command allows you to create a new table based on the result set of a SELECT statement. Here's a step-by-step guide on how to do it:

1. First, specify the new table name after the CREATE TABLE clause.
2. Then, put the AS keyword.
3. After that, add a SELECT statement to specify the data that you want to copy from the existing table to the new table.

Here's an example:

CREATE TABLE new_table AS SELECT column1, column2, ... FROM existing_table WHERE condition;

This SQL statement creates a new table named 'new_table' with the same column definitions as 'existing_table'. It also copies data from 'existing_table' to 'new_table' based on the condition specified in the WHERE clause. If no condition is specified, it copies all rows.