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

Prerequisites

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

Procedure

  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

    Name

    Description

    Refresh

    Allows you to update the table data manually.

    Detail

    Allows you to view detailed information of a specified row.

    Row Counts

    Allows you to check the total number of rows.

    Export

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

    Columns

    Allows you to filter the target columns.

    Add Row

    Allows you to add the new data.

    Delete

    Allows you to delete the selected row of the table.

    Save

    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