Help Center > > User Guide> Microsoft SQL Server Database Management> Table Management> Opening a Table

Opening a Table

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


You have obtained the login permission and logged in to the database management page.


  1. In the navigation tree on the left, right-click the target table and choose Open Table from the shortcut menu.
  2. On the displayed tab, view and manage table data.

    Table 1 Interface description




    Allows you to update the table data manually.


    Allows you to view detailed information of a specified row.

    Row Counts

    Allows you to check the total number of rows.


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


    Allows you to filter the target columns.

    Add Row

    Allows you to add the new data.


    Allows you to delete the selected row of the table.


    Allows you to save the changes to the table.

    • If the table does not have a primary key, the data can only be viewed.
    • If the table has a primary key, you can add, delete, modify, or query the table data as you do in Excel.
    • You can directly export the table data.

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