Managing a table

View or delete a table (formerly column family) in a keyspace, view metrics for a table, or truncate (delete) data from a table without deleting the table itself.

View or delete a table (formerly column family) in a keyspace, view metrics for a table, or truncate (delete) data from a table without deleting the table itself.

To manage a table:

Procedure

  1. Click Data in the left navigation pane.
  2. From the list of keyspaces, select a keyspace.
    The (#TBL) shows how many tables each keyspace contains.
  3. From the list of the tables, select a table. The CQL statement for the table appears.
    The CQL statement for the table appears.

  4. Perform any of the following actions:
    • Delete: Completely deletes the table from the keyspace. Select one or more tables in a keyspace to delete.
    • View Metrics: Presents metrics for a table. In the Metric Options dialog, select a table metric to view. To aggregate measurements across the entire cluster, all nodes in the datacenter, or in a particular node, select Cluster Wide, All Nodes, or the IP address of a node. At this point, you can add a graph of the measurements to the Performance Metrics area, or choose a different table to measure.
    • Truncate: Deletes all data from the table but does not delete the table itself.

      Warning: Removal of the data is irreversible.