Use following syntax:
alter table <Old_Table_Name> rename to <New_Table_Name>
Al.
On Wed, 8 Jul 1998, Farzad FARID wrote:
>
> How do I rename an existing database? Is it enough to just rename the
> directory? If that's the only way to do it do I have to first shut the
> server down?
>
> --
> Farzad FARID
> Administrateur Reseau
> Publicis Technology
>
>