3.2.2 Column Sequence

Mandatory.

Specify the position of the column relative to other columns in the table.

Column sequence is used to determine the physical order of the columns in the table, or the order of the columns in the table.

Rules

• Sequence numbers must be consecutive.

• The sequence number is automatically assigned when a column is added. Sequence number is updated when the order of the columns is updated in the list of columns.

Tips & Techniques

• Column sequence is not related to 3.2.3 Column Key Position. However, the key columns are typically the first columns listed in the table.

• Column sequence is important when templates are used to generate RDML code. By default, columns are listed in the physical order in the table. Generally, the most important columns will be grouped as the first columns in the table.