query to change a table name

[Dream]

can I change a table name with a query or do I need to make the whole table again?

[Adrian Schneider]

Try:
ALTER TABLE currentname
RENAME newname

[Dream]

thanks that worked great