Skip to main content Skip to complementary content

Displaying keys and indexes of database tables

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 can 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.
    Overview of the Statistical Information section.
  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.
    Contextual menu of a table from the Statistical Information section.
    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.
    Database Detail and Database Structure views with information about the primary key.
  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.
    Database Detail and Database Structure views with information about the user-defined index.
  5. To display the relevant metadata about the selected table, click any of the tabs in the Database Detail view.

Did this page help you?

If you find any issues with this page or its content – a typo, a missing step, or a technical error – please let us know!