Viewing Table Metadata

• Metadata is data used to define the type of data. It primarily describes information about the data itself, including its source, size, format, or other characteristics. In database fields, metadata interprets data content in the data warehouse.
• When creating a table, metadata is defined by three columns: column name, type, and column description.
• The Metadata page displays information about the target table, including Column Name, Column Type, Data Type, and Description.

You can view metadata on either the Data Management page or the SQL Editor page.

• To view metadata on the Data Management page:
  1. In the navigation pane on the left of the 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. In the navigation pane on the left of the management console, choose 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.