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?
- CREATE INDEX index_name ON table_name
- CREATE index_name ON table_name
- CREATE INDEX table_name
- 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.