Re: How to rename a table?

Gennady wrote in message <374da284$0$2597_at_fountain.mindlink.net>...
>Hello,
>How can I rename existing table?

To rename table X, try this:

   create table tempX as select * from X;    drop table X;
   create table X as select * from tempX;

This will work unless there are foreign keys to X.

Hope that helps,
Brian Peasland
peasland_at_msn.com Received on Thu May 27 1999 - 18:17:26 CDT