Multiple choice technology programming languages

How do you rename a table ?

  1. alter table table_name rename to new_table_name;

  2. RENAME table_name new_table_name;

  3. Dropping the table and creating once again

  4. None of the above.

Reveal answer Fill a bubble to check yourself
A Correct answer
Explanation

In SQL, the standard DDL command to rename an existing table is ALTER TABLE table_name RENAME TO new_table_name;.