Field descriptions for the database: field names, descriptions, data types, length, and order.
| Field Name | Field Description | Data Type | Field Size* | ID | The MS SQL table id number | int | 4 | TableName | The MS SQL table name | nvarchar | 256 | ColumnName | The field name in the table | nvarchar | 256 | DataType | The MS SQL data type for the field | nvarchar | 256 | Length | The length of the column | smallint | 2 | Description | Description of the field | nvarchar | 510 | FieldOrder | This field is used to set the order fields are viewed in the data dictionary update form. | smallint | 2 |
*The text datatype pre-allocates only 16 bytes. Size represents actual bytes for all other data types.