Jump to content

Archived

This topic is now archived and is closed to further replies.

mackenzie_hart

alter table rename field

Recommended Posts

hey everyone, sorry to post this question here, this is a general sql stuff, but couldnt post it to php sql forum. anyway, heres the problem: i try to rename field in a table, like this:

 

$query="ALTER TABLE table1 RENAME field1 TO field2";

 

and that wont work, dont understand where is the problem. other ALTER TABLE stuff works good. but with this i keep get this error message:

 

Warning: odbc_exec() [function.odbc-exec]: SQL error: [Microsoft][ODBC Microsoft Access -driver] Syntax Error in ALTER TABLE., SQL state 37000 in SQLExecDirect in C:\server\test.php on line 7

 

heres the whole code im using:

$conn=odbc_connect('filename','','');

$query="ALTER TABLE table1 RENAME field1 TO field2";

odbc_exec($conn,$query);

odbc_close($conn);

 

thanks. mackenzie

Share this post


Link to post
Share on other sites

×

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.