Show Contents List
You are here: Visual LANSA User Guide > 2. Editing Objects > 2.9 Tables > Add Multiple Columns to a Table
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. |