Rename a MS-Access table using SQL Query

[vishwa Ram]

Hi all,

I want sql query to rename a tablename from 'tbl1' to 'table1' globally.

My DB tables

tbl1,2,3......

Going to Rename
table1,2,3.....

Please suggest.

Reg,
Raam.

[VBPhilly]

Hi all,

I want sql query to rename a tablename from 'tbl1' to 'table1' globally.

My DB tables

tbl1,2,3......

Going to Rename
table1,2,3.....

Please suggest.

Reg,
Raam.

It will take 2 statements as there are no SQL statements to RENAME a table:

SELECT * INTO newtablename FROM oldTableName

DROP TABLE oldTableName

[ser mer]

thank you

thank you its very useful.