File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
The moose likes JDBC and Relational Databases and the fly likes Renaming a table Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Databases » JDBC and Relational Databases
Bookmark "Renaming a table" Watch "Renaming a table" New topic

Renaming a table

Preeti Chopra

Joined: May 14, 2001
Posts: 5
Hi All,
Is it possible to rename a table using JDBC. I am using MSExcel as database. Even otherwise is there any standard SQL for renaming a table.
Daniel Dunleavy
Ranch Hand

Joined: Mar 13, 2001
Posts: 276
In most databases ... NO. You could create a View to the table, which would give you the new name.
I don't know about Excel.
I agree. Here's the link:
subject: Renaming a table
It's not a secret anymore!