Home » MCQs » SQLite MCQs

What is the syntax of ALTER TABLE statement (Rename)?

81. What is the syntax of ALTER TABLE statement (Rename)?

1. ALTER TABLE table_name RENAME FOR new_table_name;
2. ALTER TABLE table_name RENAME OF new_table_name;
3. ALTER TABLE table_name RENAME TO new_table_name;
4. ALTER TABLE table_name RENAME FROM new_table_name;

Answer: C) ALTER TABLE table_name RENAME TO new_table_name;

Explanation:

The syntax of ALTER TABLE statement (Rename) is ALTER TABLE table_name RENAME TO new_table_name;