This option gives you the opportunity to create a number of columns very quickly. It is best used when you only have to add the basic details and don't need to do a lot of changes to the columns once they have been created.
Column Name | Enter the name of the column to be created. It can be a new column or one already created. For details of column names that can be used, refer to LANSA Object Names in the Technical Reference Guide. |
|---|---|
Description | If the column doesn't exist, enter the description here otherwise the description of an existing column, if selected, will be displayed. |
Reference field | If you are basing your new column on a reference field, then enter its name here. |
Type | If this is a new column, select the type of column (alpha, numeric, date, etc.) from the dropdown list. |
Length | Enter if this is a new column. |
Decs | Enter if this is a new column. |
Key * | Enter 1, 2, etc. to denote keys and their sequence. |
Virtual * | Tick (ü) if the column that you are entering is a virtual column. |
Click OK when you have entered your columns. If any of the columns are new, you are asked to confirm the column should be created.
⇑ 2.9.3 Table Columns Tab