alter table drop index

M

Mark

hi,
i want to change an indexes "Yes (No Duplicates)" property to "Yes
(Duplicates OK)". it seems only possible with alter table drop index sql ddl
command. but i can't get the correct syntax, at least i can't find out the
index name because its created within the design wizard of access 2000.
thanks
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Drop down list from index/match formula 1
Duplicate values 4
maximum number of indexes per SQL table that Access (jet) can dealwith? 0
Duplicate Records Problem 2
Dulpicate Record 6
How do I find the indices on a table in Access 2003? 4
Dropping an Error Table 4
Performance..should one index 2

Top