Home » MCQs » SQLite MCQs

What is/are the syntax of REINDEX statement?

99. What is/are the syntax of REINDEX statement?

1. REINDEX collation_name;
2. REINDEX database_name.index_name;
3. REINDEX database_name.table_name;
4. All of the above

Answer: D) All of the above

Explanation:

The syntax of REINDEX statement are -

1. REINDEX collation_name;
2. REINDEX database_name.index_name;
3. REINDEX database_name.table_name;