Updated on 2024-09-30 GMT+08:00

Viewing Table Metadata

Metadata Description

  • Metadata is used to define data types. It describes information about the data, including the source, size, format, and other data features. In database fields, metadata interprets data content in the data warehouse.
  • When you create a table, metadata is defined, consisting of the column name, type, and description.
  • The Metadata page displays information about the target table, including Column Name, Column Type, Data Type, and Description.

Procedure

You can view metadata on either the Data Management page or the SQL Editor page.
  • To view metadata on the Data Management page:
    1. On the left of the management console, choose Data Management > Databases and Tables.
    2. On the displayed Data Management page, click the name of the database where the target table whose data you want to export resides to switch to the Manage Tables page.
    3. Click More in the Operation column of the target table and select View Properties. In the Metadata tab, view the metadata of the table.
  • To view metadata on the SQL Editor page:
    1. On the left of the management console, click SQL Editor.
    2. In the navigation pane of the displayed SQL Editor page, click Databases.
    3. Click the corresponding database name to view the tables in the database.
    4. Click on the right of the table and choose View Properties from the shortcut menu. On the Metadata tab page, view the metadata of the table.