Create a non-unique index on a table

Q

quartz

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.
 
M

Marshall Barton

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.
 
Top