List:General Discussion« Previous MessageNext Message »
From:Gabriel PREDA Date:April 14 2007 8:36am
Subject:Re: renaming database
View as plain text  
Or if "RENAME DATABASE" is not implemented yet:

CREATE newDatabase;

then for each table in the oldDatabase issue:

ALTER TABLE oldDatabase.tblX RENAME TO newDatabase.tblX

After all is done:

DROP oldDatabase

-- -- -- -- -- -- -- -- -- -- -- -- -- --
Gabriel PREDA
Senior Web Developer
Thread
• renaming databaseOctavian Rasnita12 Apr
  • Re: renaming databaseMicah Stevens12 Apr
  • Re: renaming databaseGabriel PREDA14 Apr