1. Navigate to Workbench > Databases.

  2. Select the database for which you want to add or view tables.

  3. Select New Table.

  4. Type a name for the table and optionally type a description.
    The name must consist only of lower case letters, numbers, and _.

  5. Select Create.

  6. Under Schema, select Add Column.

  7. Type or select values for the fields.

  8. Optionally add more columns.

  9. Optionally, to delete a column from your table, select Edit Schema and select the x to the far right of the page.

  10. Optionally, select … > Table Settings.

  11. Optionally, make selections on Edit Settings.

  12. Optionally, select Confirm.

  13. Select Save when your schema modification is complete.

  14. Select Save when you are done defining columns.

TD Toolbelt Example

The table:create command creates a table named test_table within the database test_db.

$ td table:create test_db test_table

The tables command lists the tables and the number of records in each table for a given database.

$ td tables test_db

Use the tables command without specifying a database name to list all the databases and tables that you have created. For example:

$ td tables
  • No labels