Modify Existing Column Properties

Learn how to modify existing column properties by following these steps:

 

Steps

1. Go to the System Manager module.
   
   
   
2. Select Customize > Data Dictionary button from the menu. The Data Dictionary form will display.
   
3. The Database Objects List on the left lists all tables, views and stored procedures (from your existing system views and tables as well as custom views and tables created in the data dictionary).
   
   
   
4. To modify an existing column property,
   
   
   1. Select the views in the Data Dictionary Objects list. The views are arranged in an alphabetical manner so you can search for the view by typing in the first few letters of the view name from the System Views folder.
      
      
      
   2. You may modify the column properties in the Column tab.
      
      
      

The table below shows the fields' description.

Field	Description
Column Name	shows the column name or field name in the table or form.
Type	shows the type of data supported (alphanumeric, numbers only, date etc.).
Length	shows the maximum recommended length of characters
Sort Order	shows the sort order of the field in the form. You can rearrange the sort order of the fields by changing their sort order number.
Default	shows the default value for the field.
Search Mapping	Select the value to which the column should be mapped. This is useful in finding specific searches in the forms. See: Using the Seach Manager