Adding or modifying Table fields in Database Manager

Use the Fields tab in the Database Manager view to add or modify the table field.

Note: The system administrator can only access these features. These features are not available in Oracle environments.
  1. Select Administration > Database Manager on the navigation bar. The Database Manager list view is displayed.
  2. Click the Fields tab in the Detail pane.
  3. Click Add to add a new table index.
    Note: To modify a field, select the field and click Edit.
  4. Specify this information:
    Field Name
    The name of the field.
    Note: You cannot use Microsoft SQL Server or Oracle keywords or reserved words as a field name.
    Display Name
    The field name to be displayed in the Query builder.
    Note: If the value in this field is not specified, the Field Name value is used.
    Field Type
    The type of field. Possible values:
    • SLX Standard ID
    • SLX Boolean (char 1)
    • nvarchar
    • big int
    • small int
    • int
    • float
    • nchar
    • datetime
    • numeric
    • decimal
    • nvarchar (max)
    • varbinary (max)
    • ntext
    Note: This value cannot be modified.
    Field Length
    The length of the field in bytes if the Field Type is set to nvarchar.
    Description
    The additional information related to the purpose of the field.
    Auto Increment
    Select this check box to identify each entry by a unique number.
    Note: This option is only applied to the primary key column.
    Nullable
    Select this check box to permit null values.
  5. Click OK.
Related topics