Page 1 of 1

changing database table name

Posted: Sun Jun 18, 2006 12:01 pm
by mickd
Hey,

is it possible to rename a database table name without dropping it, recreating it and readding all its previous entries?

Thanks.

Posted: Sun Jun 18, 2006 12:22 pm
by printf
Something like...

Code: Select all

ALTER TABLE old_table_name RENAME new_table_name;

pif!

Posted: Sun Jun 18, 2006 1:00 pm
by mickd
Ah, cool thanks.

Got to remember to rt_m.