Rename Table 1

[NetworkGuy101]

I am haveing trouble renaming a table Here is my query.
<cfquery datasource=&quot;353EXDB&quot;>
Rename table copymseltest to copymsel
</cfquery>
I am getting this error
ODBC Error Code = 37000 (Syntax error or access violation)


[Microsoft][ODBC Microsoft Access Driver] Invalid SQL statement; expected 'DELETE', 'INSERT', 'PROCEDURE', 'SELECT', or 'UPDATE'.

 

[Wullie]

Hi mate,

Looks like the ODBC connection is not setup to allow you access to RENAME, check with your server admin or check the DSN setup yourself if you are the admin.

Hope this helps

Wullie

http://www.freshlookhosting.com

http://www.tutorial-world.com

http://www.freshlookdesign.co.uk

The pessimist complains about the wind. The optimist expects it to change. The leader adjusts the sails. - John Maxwell

 

[r937]

microsoft access does not have a RENAME command, as far as i know

i realize this won't help a cf programmer, but have a look at this article:

http://www.4guysfromrolla.com/webtech/tips/t030802-1.shtml

rudy

http://r937.com/

SQL Consulting

 

[NetworkGuy101]

Is there a way to copy the table?

 

[r937]

oh sure

select * into newtablename from oldtablename

rudy

http://r937.com/

SQL Consulting

 

[NetworkGuy101]

Your awesome Rudy I dont care what they say about you.

 

[r937]

what do they say? anything negative? tell me who... because i want to track them down...




p.s. thanks for the star

rudy

http://r937.com/

SQL Consulting

 

[TruthInSatire]

I agree, rudy is good with his sql and db knowledge!

http://thereptilian.com/