Is this what you are looking for?
RENAME TABLE tbl_name TO new_table_name[, tbl_name2 TO new_table_name2,...]
Just take a look at the manual!
Cheers, Nessi
At 09:22 22/06/01 , you wrote:
>how do i change a table's name without recreating it?
>
>---------------------------------------------------------------------
>Before posting, please check:
> http://www.mysql.com/manual.php (the manual)
> http://lists.mysql.com/ (the list archive)
>
>To request this thread, e-mail <[EMAIL PROTECTED]>
>To unsubscribe, e-mail <[EMAIL PROTECTED]>
>Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
