In SQL which keyword is used to rename a table

In sql which keyword is used to rename a table - CompTIA DataSys+ DS0-001

Question

In SQL, which keyword is used to rename a table?

Answers

RENAME TO
correct

ALTER TABLE RENAME
MODIFY TABLE NAME
CHANGE TABLE

Explanation

Correct Answer: B. ALTER TABLE RENAME

The ALTER TABLE RENAME command is used in SQL to rename an existing table. This command modifies the structure of a table, allowing you to change its name without affecting the data it contains. It is a part of the Data Definition Language (DDL) in SQL.

The syntax typically looks like: ALTER TABLE old_table_name RENAME TO new_table_name;. This approach ensures data preservation while changing the table identifier.

Why Other Options are Incorrect:

A. RENAME TO: This is not a valid standalone SQL command. While RENAME TO may appear in combination with ALTER TABLE, using it alone without the full context (ALTER TABLE) is syntactically incorrect in most SQL dialects, such as MySQL or PostgreSQL.
C. MODIFY TABLE NAME: This is not a recognized SQL syntax. The MODIFY keyword is used to change column definitions within a table, not to rename the table itself. SQL does not support MODIFY TABLE NAME as a valid command for renaming.
D. CHANGE TABLE: CHANGE is typically used in SQL (especially MySQL) to alter column names or data types, not entire table names. There is no valid SQL command that begins with CHANGE TABLE for renaming a table, so this is syntactically invalid.