Viewing columns used by a table

Before you start, you must complete a table search task. See Searching for tables.

  1. On the Search Results tab, select a Table name.
    A new search result opens with the header Table Relation Type: Total match.
  2. On the bar at the top, click Table Column to show all the columns used by your selected table.
    A new search result opens with this information:
    Column Name
    Name of the column used by your selected table.
    Description
    Description of the column used by your selected table.
    Data type
    Data type of the column used by your selected table.
    Length
    Length of the column used by your selected table.
    Decimals
    Decimals of the column used by your selected table.
    Edit Code
    Edit Code of the column used by your selected table.
    Index
    List of index names for your selected table column.
  3. Use these options to sort and filter your results.

    • To sort the results alphabetically or numerically, click the Sort icon located in one or more column headings.

    • To filter the results, type a dynamic free text filter for each column and select a Filter action.