Updated on 2023-03-28 GMT+08:00

Table Management

Procedure

  1. On the top menu bar, click Database Management. In the Select Database dialog box, select a database and click OK.
  2. Click + in front of a table name to view the Column, Indexes, and Foreign Keys of the current table.

    Click Column to view Column Name, Type, and Index Type of the current table. In Operation column, you can perform following operations:
    • Click Adjust security level and configure Is it a sensitive field.
    • Click Adjust Log to view when the column was modified and the user who has modified the column.
    • Click Permission Change Log to view the authority type, dredge way, and dredge time.

  3. On objects details page, in Operation column, you can perform following operations:

    • Click Query to go to the SQL Window page and perform SQL query.
    • Click Open to go to the details page of the current table. You can view the name, type, and other information of the current table.
    • Click View. A text box is displayed, showing Basic Information about the current table, including the database name, table name, and number of rows.
    • In this text box, you can also click SQL Statements for Creating Table to view details about the SQL statements for creating this table.