MySQL UI provides four table-level operations that go beyond editing data or schema: renaming a table, duplicating it, clearing all its rows, and deleting it entirely. These actions are all available from the toolbar at the top of the table panel.Documentation Index
Fetch the complete documentation index at: https://docs.w22.dev/llms.txt
Use this file to discover all available pages before exploring further.
Accessing the menu
Select a table from the sidebar, then click the ⋮ (more options) button in the top-right corner of the table panel. A dropdown menu lists all available operations.Operations
Rename table
Rename table
Click Rename table in the menu. A dialog opens pre-filled with the current table name.
- Edit the name to your desired value.
- Click Rename to confirm.
Duplicate table
Duplicate table
Click Duplicate table in the menu. A dialog opens with a suggested name based on the current table (for example,
orders_copy).- Enter the name for the new table.
- Click Duplicate to confirm.
Truncate table
Truncate table
Click Truncate table in the menu. A confirmation dialog explains that all rows will be permanently deleted.Click Truncate to proceed.Every row in the table is deleted, but the table itself — its columns, indexes, and constraints — remains intact. The table is empty and ready to accept new data.
Drop table
Drop table
Click Drop table in the menu. A confirmation dialog warns that the table and all of its data will be permanently deleted.Click Drop Table to proceed.The table is removed from the database entirely and disappears from the sidebar.
Operation summary
| Operation | Removes rows? | Removes table? | Reversible? |
|---|---|---|---|
| Rename | No | No | Yes (rename back) |
| Duplicate | No | No | Yes (drop copy) |
| Truncate | Yes (all) | No | No |
| Drop | Yes (all) | Yes | No |