Viewing columns used by a table

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

  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 heading Description
    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.