SqlColumnNumber (Property Keyword)
Specifies the SQL column number for this property. Applies only to persistent classes.
Usage
To specify the SQL column number for the property, use the following syntax:
Property name As classname [ SqlColumnNumber = 4 ];
Where n is a number between 2 and 4096, inclusive.
Details
This keyword lets you explicitly set the SQL column order for this property. The SQL column order is used when querying the table through a SELECT * statement, or using an INSERT or LOAD DATA command without specifying the column order explicitly.
Setting this property keyword enables you to decouple the order implied by your class definition from the SQL projection of this class as a table.
Default
The default is an empty string.
