Displaying keys and indexes of database tables - Cloud

Talend Cloud Data Management Platform Studio User Guide

Version
Cloud
Language
English (United States)
Product
Talend Cloud
Module
Talend Management Console
Talend Studio
Content
Design and Development
After analyzing the content of a database, you can display the details of the key and user-defined index of a given table. This information could be very interesting for the database administrator.

Before you begin

At least one database content analysis has been created and executed in the Profiling perspective of Talend Studio.

Procedure

  1. In the Analysis Results view of the analysis editor, click a catalog or a schema under Statistical Information.
    All the tables included in the selected catalog or schema are listed along with a summary of their content: number of rows, keys and user-defined indexes.
  2. In the table list, right-click the table and select View keys.
    You cannot display the key details of tables in a Hive connection.
    The Database Structure and the Database Detail views display the structure of the analyzed database and information about the primary key of the selected table.
  3. Optional: If one or both views do not show, select Window > Show View > Database Structure or Window > Show View > Database Detail.
  4. In the table list, right-click the table and select View indexes.
    You cannot display the index details of tables in a Hive connection.
    The Database Structure and the Database Detail views display the structure of the analyzed database and information about the user-defined index of the selected table.
  5. If required, click any of the tabs in the Database Detail view to display the relevant metadata about the selected table.