Help Center > > User Guide> Microsoft SQL Server Database Management (Standard Edition)> Table Management> Opening a Table

Opening a Table

Updated at:Mar 20, 2020 GMT+08:00

Prerequisites

You have logged in to the DAS console.

Scenarios

If the table has a primary key, you can add, delete, modify, or query the table data as you do in Excel.

Procedure

  1. On the top menu bar, choose Database Management. On the displayed Objects tab, choose Tables on the left, locate the target table, and click Open in the Operation column.
  2. On the table details page, double-click a cell to edit data. After adding or editing data, submit and save the changes.

    Table 1 Interface description

    Name

    Description

    Where Condition

    The WHERE clause is used to filter records.

    Copy Row

    Select the target row and then click Copy Row. The data of the row is copied.

    Copy Column

    Click the Copy Column drop-down list and choose the column to be copied.

    Column Settings

    Allows you to filter the target columns.

    Refresh

    Allows you to update the table data manually.

    Row Details

    Allows you to view detailed information of a specified row.

    Add

    Allows you to add rows.

    Submit

    Allows you to submit and save the changes to the data.

    Delete Row

    Allows you to delete the selected row of the table.

    Export

    Allows you to export the CSV or SQL file with a maximum of 10,000 records.

Did you find this page helpful?

Submit successfully!

Thank you for your feedback. Your feedback helps make our documentation better.

Failed to submit the feedback. Please try again later.

Which of the following issues have you encountered?







Please complete at least one feedback item.

Content most length 200 character

Content is empty.

OK Cancel