Skip to content
Last updated

Creating or Viewing Tables

You can create or view a table by:

  1. Navigate to Data 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.

  1. Optionally, make selections on Edit Settings.

  1. Optionally, select Confirm.

  2. Select Save when your schema modification is complete.

  3. 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