Of course there is...

ALTER TABLE name RENAME newname ;

Of course you can find this sort of thing in the manual of even on Quetin
Smith's SQL reference site... http://comclub.dyndns.org:8081/sqlref/

Cheers,
Mikel

Don wrote:

> Hi,
>
> Is there a quick and simple way to change the name of a Table that is
> contained within my database?
>
> Thanks,
> Don
>
> ---------------------------------------------------------------------
> 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


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

Reply via email to