Create a new index

Creates a new index (similar to creating a table). Supply the index name in the WITH clause. To have the call fail if the index already exists, set ContineOnErrorForStatusCode=0.

SELECT * FROM create_index WITH(Name='my_new_index_name', ContineOnErrorForStatusCode=1)