[thelist] Altering Design of AccessTable from Coldfusion

rudy r937 at interlog.com
Wed Mar 13 23:23:01 CST 2002

> I need to set the "Indexed" field of a table (as seen in the
> Design view when you open up a table in MS Access) to
> "Yes (No Duplicates)". You gotta be able to do this remotely
> by sql, right? I know this can be done in MySQL...

hi jon

sorry for the huge delay in replying

yes it's possible

No Duplicates implies unique, so your query would be

  create unique index yourIndex
       on YourTable ( yourColumn )


   HOWTO: Common DDL SQL for the
   Microsoft Access Database Engine (Q180841)


More information about the thelist mailing list