Home » MCQs » Transact-SQL (T-SQL) MCQs

Which of the following is the correct syntax to create an index?

44. Which of the following is the correct syntax to create an index?

1. CREATE INDEX index_name ON table_name
2. CREATE index_name ON table_name
3. CREATE INDEX table_name
4. Create INDEX on table name/ index name

Answer: A) CREATE INDEX index_name ON table_name

Explanation:

CREATE INDEX index_name ON table_name, is the correct syntax to create an index.