Reference Tables in the Analyst Tool > Reference Table Properties
  

Reference Table Properties

You can view and edit reference table properties in the Analyst tool. A reference table displays general properties that describe the repository object and column properties that describe the column data.
To view the properties, open the reference table and select the Properties panel.
To edit the properties, open the reference table and click Actions > Edit Table.

Reference Table Column Properties

The column properties contain information about the column metadata.
The following table describes the column properties:
Property
Description
Name
Name of each column.
Data Type
The data type for the data in each column. You can select one of the following data types:
  • - bigint
  • - date/time
  • - decimal
  • - double
  • - integer
  • - string
You cannot select a double data type when you create an empty reference table or create a reference table from a flat file.
Precision
Precision for each column. Precision is the maximum number of digits or the maximum number of characters that the column can accommodate.
The precision values you configure depend on the data type.
Scale
Scale for each column. Scale is the maximum number of digits that a column can accommodate to the right of the decimal point. Applies to decimal columns.
The scale values you configure depend on the data type.
Description
Optional description for each column.
Nullable
Indicates if the column can contain null values.
Key
Identifies a key column. The Analyst tool can identify a key column if you import the reference data from a table that specifies a key column.