That's what I was afraid of.
Thanks for the heads up.
Jake
Daniel Elmore wrote:
I don't think access supports RENAME COLUMN, you going to have to create a new col, copy data, then drop the old col.
-----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Jake McKee Sent: Sunday, April 24, 2005 11:30 PM To: [email protected] Subject: Rename Access table name
All,
I'm trying to use a SQL statement to rename a column in an Access database. This is the code:
<cfquery name="update" datasource="#APPLICATION.datasource#"> ALTER TABLE otherBlogs RENAME COLUMN status TO otherBlogStatus </cfquery>
I'm getting a CF error saying that there is a syntax error here. Any ideas what's going on?
Thanks! Jake
----------------------------------------------------------
To post, send email to [email protected]
To unsubscribe: http://www.dfwcfug.org/form_MemberUnsubscribe.cfm
To subscribe: http://www.dfwcfug.org/form_MemberRegistration.cfm
----------------------------------------------------------
To post, send email to [email protected]
To unsubscribe: http://www.dfwcfug.org/form_MemberUnsubscribe.cfm
To subscribe: http://www.dfwcfug.org/form_MemberRegistration.cfm
----------------------------------------------------------
To post, send email to [email protected]
To unsubscribe: http://www.dfwcfug.org/form_MemberUnsubscribe.cfm
To subscribe: http://www.dfwcfug.org/form_MemberRegistration.cfm
