Tables are the fundamental database object, and Columns (and their properties) are the most frequently modified Table feature updated and changed by data modelers, therefore the 'Columns' page is conveniently located as the first page of the Database Builder's interface.
Once a Table is selected in the Database Builder's tree, the 'Columns' page is populated with the currently defined list of columns for that Table. The data modeler can then make changes to main column properties directly in the list or grid. As the data modeler selects individual columns in the list, the column's extended properties (and Comments) are shown immediately under the list, allowing modification to these extended properties.
This figure show the Database Builder interface showing the tree of objects and the Columns tab showing the Columns for the selected table.
- The 'Columns' page will only be populated when a Table item is selected in the Database Builder's tree