Opening a Table
If a table has primary keys, you can add, delete, modify, or query table data as you do in Excel.
Procedure
- Click
in the upper left corner and select a region and project. - Click
in the upper left corner, and under Databases, click Data Admin Service. - In the navigation pane on the left, choose Development Tool.
- Locate the DB instance that you want to log in to and click Log In in the Operation column.
- On the top menu bar, choose Keyspace Management.
- Click Change Keyspace on the right of the current keyspace to switch to the keyspace where you want to open a table.
- On the displayed Objects tab, choose Tables on the left. In the table list, locate the table you want to open, and click Open in the Operation column.
- On the table details page, double-click a cell to edit data. After adding or editing data, submit and save the changes.
Table 1 UI operations Name
Description
Where Condition
Filters records.
Copy Row
Copies data of the selected row. Specifically, double-click the target row and then click Copy Row.
Copy Column
Allows you to copy all data in a column by selecting this column from the Copy Column drop-down list.
Column Settings
Allows you to set the columns you want to display.
Refresh
Allows you to update table data manually.
Row Details
Shows details of a specified row.
Add Row
Allows you to add rows.
Submit
Allows you to submit and save the changes to data.
Delete Row
Allows you to delete the selected rows.