[thelist] Altering Design of AccessTable from Coldfusion

Raymond Camden jedimaster at macromedia.com
Mon Mar 11 07:27:01 CST 2002

If it's possible via SQL's ALTER command, you can do it. Just do:

<cfquery .......>
	alter ....

Raymond Camden, Principal Spectra Compliance Engineer for Macromedia

Email    : jedimaster at macromedia.com
Yahoo IM : morpheus

"My ally is the Force, and a powerful ally it is." - Yoda

> -----Original Message-----
> From: thelist-admin at lists.evolt.org
> [mailto:thelist-admin at lists.evolt.org] On Behalf Of jon steele
> Sent: Saturday, March 09, 2002 12:44 PM
> To: TheList Evolt
> Subject: [thelist] Altering Design of AccessTable from Coldfusion
> Hi list,
> I was wondering how to change the design of an Access table
> via sql from coldfusion? Can this be
> done with a sql query or is something else needed?
> 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...
> Any help is appreciated as always.
> Jon

More information about the thelist mailing list