Thread: How to rename a database?

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

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
>
>

> Use following syntax:
> alter table <Old_Table_Name> rename to <New_Table_Name>
>
>

I don't think that will work for the entire database.  Remember a table is
part of the database.  So I don't think alter will change the actual
database's name...

> >
> > 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
> >
> >