Skip to main content

SqlColumnNumber (Property Keyword)

Specifies the SQL column number for this property. Applies only to persistent classes.


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.


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.


The default is an empty string.

See Also

FeedbackOpens in a new tab