Can anybody tell me how to rename a table in VB?

Hard to believe this simple task is not a straightfowdard feature. Maybe it's so straightforward that I'm missing something?

I have resorted to creating a new table (with the new name desired) copying all contents from it to the new renamed table, then dropping the old one.

Surely there must be a better and faster way? If the table contains a lot of records, there is a big delay with my method.

I have tried

dbs.execute("RENAME TABLE name1 TO name2")
but this does not work.

Any help is appreciated.