Create a non-unique index on a table

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Could someone please tell me what the correct SQL syntax is to create a
NON-unique index (ascending) on a field in an existing AccessXP table?

Thanks much in advance.
 
quartz said:
Could someone please tell me what the correct SQL syntax is to create a
NON-unique index (ascending) on a field in an existing AccessXP table?
Click to expand...


Execute an SQL DDL statement:

CREATE INDEX index ON table (field ASC)

or you could do it with an ALTER TABLE statement. See Help
- Contents - SQL Reference - Data Definition Language.
 
Back
Top