sql: add a create index example using a named index

[awoods187]

Andy Woods (awoods187) commented:

None of the examples in https://www.cockroachlabs.com/docs/v19.1/create-index.html#main-content show that you can name the index as you create it. I think it'd be nice to have one example like:

create index vehicles_auto_index_fk_city_ref_users on vehicles (city ASC, owner_id ASC);

With one or two sentences that explain this can be done. We mention that you can rename index in Alter Index https://www.cockroachlabs.com/docs/v19.1/alter-index.html.

Jira Issue: DOC-339

[zuliatowoade]

@Amruta-Ranade I will like to work on this issue. Do you mind assigning it to me. Thank you.

[zuliatowoade]

@ericharmeling should this change be made to version 19.1, 19.2, 20.1 and 20.2? I plan on using the example @awoods187 provided above. However, I was wondering, does the "ASC" need to be explicitly stated? Thanks

[zuliatowoade]

@Amruta-Ranade @awoods187 Can either of you assist with the question I had sent to @ericharmeling above? Thanks.

[Amruta-Ranade]

Hey! Yes, all three versions need to be updated. And I think ASC needs to be explicitly stated. cc @ericharmeling for confirmation :)

[ericharmeling]

@zuliatowoade

So sorry for the delay in response!!

• Versions 19.2, 20.1., and 20.2 need to be updated. Please be sure to use the latest minor release of CockroachDB for each of these respective versions (e.g., https://www.cockroachlabs.com/docs/releases/v19.2.11.html, https://www.cockroachlabs.com/docs/releases/v20.1.8.html, and https://www.cockroachlabs.com/docs/releases/v20.2.0-rc.4.html).

• ASC does not need to be explicitly specified, since this keyword specifies to use the default ordering pattern (see https://www.cockroachlabs.com/docs/stable/query-order.html#parameters).