Re: ** How to rename a database

rename database <old_db_name> to <new_db_name> note: No one can have <old_db_name> open while you are doing this -Bill } } >> : Does anyone know a slick and quick way of renaming a database? } >> } >> Not without recreating the database, at least in V5. You can do it } with } >> one command in V7. } } What is that command? In my 7.1 SQL Syntax manual I can only find } RENAME COLUMN and RENAME TABLE statements. Did they add that in 7.2? } } } Mark Collins } mcollins@us.dhl.com } -- Bill Ennis Voice: 312-474-7516 SSA Fax: 312-474-7460 500 W. Madison email: ennis@ssax.com ennis@accesschicago.net