Is there a way to move a table to a different database?

[Michal Singer]

Hi, I create a table under default database and now i want to move it to a different database.

Is there a way to do this?

Thanks

[Muli Golan]

1. Create the table in the database you would like it to be in.

2. detach all partitions from old table

3. move the files of the detached partitions to the folder detached under the new table name

4. attach the partitions

[Michal Singer]

Thanks, is there a simpler way to do this?

[Denis Zhuravlev]

Rename table old_db.t to new_db.t