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