github.com/cockroachdb/cockroach@v20.2.0-alpha.1+incompatible/docs/generated/sql/bnf/create_index_stmt.bnf (about) 1 create_index_stmt ::= 2 'CREATE' ( 'UNIQUE' | ) 'INDEX' opt_concurrently opt_index_name 'ON' table_name ( 'USING' name | ) '(' ( ( ( column_name ( 'ASC' | 'DESC' | ) ) ) ( ( ',' ( column_name ( 'ASC' | 'DESC' | ) ) ) )* ) ')' opt_hash_sharded ( ( 'COVERING' | 'STORING' | 'INCLUDE' ) '(' name_list ')' | ) opt_interleave opt_partition_by opt_where_clause 3 | 'CREATE' ( 'UNIQUE' | ) 'INDEX' opt_concurrently 'IF' 'NOT' 'EXISTS' index_name 'ON' table_name ( 'USING' name | ) '(' ( ( ( column_name ( 'ASC' | 'DESC' | ) ) ) ( ( ',' ( column_name ( 'ASC' | 'DESC' | ) ) ) )* ) ')' opt_hash_sharded ( ( 'COVERING' | 'STORING' | 'INCLUDE' ) '(' name_list ')' | ) opt_interleave opt_partition_by opt_where_clause 4 5