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.
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.
In MySQL you can do:
ALTER TABLE `oldname` RENAME `newname`;
ALTER TABLE `oldname` RENAME `newname`;
Thank you. i will have a try.
but i am not sure about in Masm32+ODBC programming.
but i am not sure about in Masm32+ODBC programming.