How would I write the SQL statement to create an index?

Question

For the column Custno and in a Customer table

Answer 1

Build it in access using a Query, do to view, view sql.

Answer 2

create index iCustNo on Customer (Custno)

if you want the index to be unique as in this table custno would be unique, use following

create unique index iCustNo on Customer (Custno)
This will prevent creating duplicate custnumbers in the table.

Answer 3

Format is
CREATE INDEX index_name
ON table_name (column_name)

Example is
CREATE INDEX idx_CustNo
ON Customer (Custno)

Answer 4

CREATE INDEX IDX_CUSTOMER_CUSTNO
ON CUSTOMER(CUSTNO);