[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 )
see
HOWTO: Common DDL SQL for the
Microsoft Access Database Engine (Q180841)
http://support.microsoft.com/default.aspx?scid=kb;EN-US;q180841
rudy
More information about the thelist
mailing list