Home » Forums » The Heap » SQL question: how to modify a table's name?

SQL question: how to modify a table's name?
invoke ....

there is a table named Table_A in Access database file somedata.mdb.
i want to change the name Table_A into Table_B.
this is my solution:

select * into Table_B from Table_A where true
drop table Table_A
select * into Table_A from Table_B where true
drop table Table_B

it works, but is boring
is there any neat solution for that problem?
thanks a lot.
Posted on 2005-05-23 22:27:04 by zhihui
Re: SQL question: how to modify a table's name?
In MySQL you can do:

ALTER TABLE `oldname` RENAME `newname`;
Posted on 2005-05-24 09:15:54 by comrade
Re: SQL question: how to modify a table's name?
Thank you. i will have a try.
but i am not sure about in Masm32+ODBC programming.
Posted on 2005-05-24 23:34:23 by zhihui